November 1, 2011 at 3:07 am
Hi,
1.Disabled all the logshipping jobs i.e backup job in Primary and copy/restore jobs in secondary
2.Rebooted the primary server
3.Brought the secondary into online with latest log backup.
Now, I want to make secondary database in Readonly/Standby mode.
So, I've tried to take a log backup of the primary and restored on secondary as readonly mode/standby mode
RESTORE LOG databasename FROM DISK = 'D:\Logshipping\infiniscale\databasename_tlog_201111010354.TRN'
WITH STANDBY ='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ROLLBACK_UNDO_databasename.BAK'
But unfortunately it's not working for me...throwing error
Server: Msg 4306, Level 16, State 1, Line 1
The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY.
Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
Now my question is..
Can't we bring secondary back as read-ony by using Tlog backup?
or
can we only bring secondary as read-only with latest full backup of primary ?
Please advice.
Thanks and Regards,
Ravi.
November 7, 2011 at 12:35 pm
ravisamigo (11/1/2011)
Hi,Now my question is..
Can't we bring secondary back as read-ony by using Tlog backup?
or
can we only bring secondary as read-only with latest full backup of primary ?
Please advice.
Thanks and Regards,
Ravi.
1) No, You can not restore Tr Log after you brought DB online
2) Yes, You can restore Full backup with Standby, Replace options
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply