Database Snapshot on LS secondary
-
Friday, January 04, 2013 4:39 AM
Is it possible to create DB snapshot on LS secondary server?
Manish
All Replies
-
Friday, January 04, 2013 9:34 AM
Its not possible to create Database snapshot in Log shipped secondary server.
If you are looking secondary server for reporting purpose, then you can use Standby mode of log shipping- Edited by Srinivasan Ram Friday, January 04, 2013 9:39 AM
- Proposed As Answer by Allen Li - MSFTModerator Monday, January 07, 2013 6:20 AM
- Marked As Answer by Allen Li - MSFTModerator Monday, January 14, 2013 3:18 AM
-
Friday, January 04, 2013 1:19 PMModerator
Hello,
"In a log shipping configuration, database snapshots can be created only on the primary database, not on a secondary database".
http://msdn.microsoft.com/en-us/library/ms175158.aspx
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com- Proposed As Answer by Allen Li - MSFTModerator Monday, January 07, 2013 6:20 AM
- Marked As Answer by Allen Li - MSFTModerator Monday, January 14, 2013 3:19 AM
.png)
