March 4, 2009 at 8:52 pm
Hi
I ran the following restoring command during the logshipping but it has failed and through the following error
Restore Database XXX from disk = 'L:\Backups\XXX_DB.BAK'
with replace, NORECOVERY, standby = 'L:\XXX_TL_Backups\Standby\XXX_undo.ldf',
Move 'XXX_Data' To 'S:\DATA\XXX_DATA\XXX_DATA.MDF',
Move 'XXX_Log' To 'L:\LOGS\XXX_LOG\XXX_LOG.LDF',
Move 'Index_Data' To 'I:\INDEXES\XXX_INDEXES\INDEX_DATA.NDF'
Server: Msg 3031, Level 16, State 1, Line 1
Option 'norecovery' conflicts with option(s) 'standby'. Remove the conflicting option and reissue the statement.
what is mistake in this command...pls help me to resolve.
March 4, 2009 at 9:35 pm
NORECOVERY and STANDBY are mutually exclusive: you can have one or the other but not both.
If you want users to be able to have read-only access to the log-shipped database use Standby, otherwise use NoRecovery because your restores could be much quicker because there's no roll-forward/roll-back of incomplete transactions after each log file is restored.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply