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