lilywhites (4/22/2014)
Each restore in the chain is running using the STANDBY file....i was wondering if we could remove these STANDBY commands and just use it at the end of the chain?? The only other alternative is to repeat the SET SINGLE_USER WITH ROLLBACK IMMEDIATE command before each restore??thanks
In this case, once the database mode has been altered to SINGLE_USER, just run each restore with the norecovery option and the last with standby. Note that all restores will need to be done through the same session when using SINGLE_USER.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉