|
Home > Archive > MS SQL Server > February 2006 > Sql Server 6.5 DR server Backup Load???
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sql Server 6.5 DR server Backup Load???
|
|
| Sreejith G 2006-02-06, 11:23 am |
| Hi,
I have with me Sql Server 6.5 production server and its DR server(read only,
truncate log on checkpoint, no checkpointon recovery => option's set ). I
hourly refresh DR server with log from production. Due to some issue i had to
re create DR server DB. After recreating i loaded it with latest full backup
from production but failed to set the DR DB option's => read only, truncate
log on checkpoint, no checkpointon recovery.
Now my question is after full DB refresh i changed DR DB options to read
only, trun..... Will next log load from production fail in DR server?
Thanks,
Sree
| |
| Sreejith G 2006-02-07, 7:23 am |
| Hi,
It didnt hurt much this time :)... I changed the DB options just after
loading the full backup. Waited till the next log load happens, and there was
no issue:).
Thanks,
Sree
"Sreejith G" wrote:
> Hi,
>
> I have with me Sql Server 6.5 production server and its DR server(read only,
> truncate log on checkpoint, no checkpointon recovery => option's set ). I
> hourly refresh DR server with log from production. Due to some issue i had to
> re create DR server DB. After recreating i loaded it with latest full backup
> from production but failed to set the DR DB option's => read only, truncate
> log on checkpoint, no checkpointon recovery.
>
> Now my question is after full DB refresh i changed DR DB options to read
> only, trun..... Will next log load from production fail in DR server?
>
> Thanks,
> Sree
>
>
>
>
|
|
|
|
|