- I have a "log shipping" from server A(Database Name = main) to server B(Database Name = LS_main) .
- 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