Friday, January 04, 2013 4:39 AM
Is it possible to create DB snapshot on LS secondary server?
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
Friday, January 04, 2013 1:19 PMModerator
"In a log shipping configuration, database snapshots can be created only on the primary database, not on a secondary database".
Hope this helps.