mardi 3 mars 2015

How to change the database mode to STANDBY?



  1. I have a "log shipping" from server A(Database Name = main) to server B(Database Name = LS_main) .

  2. I want to take a Snapshot Database From the secondary Database (Database Name = LS_main), but he id in STANDBY mode (Read_only) and I can't do it.


How can I do it ?


(I Thought that I can change the DatabaseLS_Main from Standby mode to FULL recovery mode, take the snapshot and bring him back to STANDBY mode...is it right to do ?)





Aucun commentaire:

Enregistrer un commentaire