November 14, 2007 at 7:31 am
Hi Experts,
I have restored a database as normal and wish to know if I can change it to be in STANDBY or NO RECOVERY mode without having to restore it again into that mode.
Is there a way to change it if it already exists? I want to use it as a secondary db in a log shipping procedure.
Thanks,
November 15, 2007 at 7:07 am
You can change to read only mode but not to stand by or recovery mode after a full restoration.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
November 19, 2007 at 7:38 am
You have to re-run the restore and use the WITH NORECOVERY or STANDBY options during the restore.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply