4

The normal way to do backups would be:

enter image description here

But can you have your cake and eat it too?

Can you put a DB into WITH RECOVERY state, i.e. bring it online, and still subsequently try to do further differential or log restores on top?

Improve this question

1 Answer 1

Reset to default
10

Can you put a DB into WITH RECOVERY state, i.e. bring it online, and still subsequently try to do further differential or log restores on top?

Yes, you'd want to specify that it's for STANDBY and give it an UNDO file location so that the engine can rollback any uncommitted transactions and bring the database to a known good state. The database will be accessible in read-only mode after using the STANDBY option.

Example:

RESTORE LOG MyDatabase FROM DISK = 'x:\Some\Location\File.trn' WITH STANDBY = 'x:\Another\Place\StandbyFileForMyDatabase.tuf'

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.