standby not a recognized RESTORE option

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 1

I think the standby option is required to be set to an undo file file, like this:

STANDBY = undo_file_name

check it out in BOL

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

Scorpion_66 SSCertifiable Points: 7891 More actions · Answer 2

When you use standby, you should give it the undo file name. That will fix your problem.

zach_john SSCertifiable Points: 5922 More actions · Answer 3

Don't remember having to use the undo file before, but that seems to be it.

I'm definitely losing it!

btw - i did read bol - just decided to ignored it.

lousy error message, Standby is a valid option -just need a undo file.

thanks all

John Zacharkan