lundi 9 février 2015

Is it possible to set stand-by database to active, do changes and then continue restore chain?


Basically, I'm using a custom log shipping method on a sql 2012, where the transaction files are manually copied to an offsite location. The files are then restored using something similar:



RESTORE LOG xyz
FROM MyAdvWorks_log2
WITH STANDBY = 'c:\undo.bak'


I would really like to be able to set that stand-by database briefly to Active, do various stuff (not just read) and then rollback/discard those changes and allow the restore to continue.


Is that even possible? If not, can I copy the stand-by server and set it to active (and then when I'm done, delete it)?





Aucun commentaire:

Enregistrer un commentaire