snapshot on Mirrordb

• sandhyarao49

  SSCrazy

  Points: 2215

  More actions

  May 3, 2010 at 6:41 am

  #142803

  Hi,

  For some of the reporting needs we want to enable snapshot for the mirrored database, but when I want to create a snapshot from the Mirror Db it is giving error

  “The database "XXXXX" cannot be opened. It is acting as a mirror database.”

  Can anyone throw light how to create a snapshot from the Mirror DB.

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  May 3, 2010 at 2:22 pm

  #1161499

  Could you please post the script that you are using for creating the snapshot database.

  Example stated at-->http://technet.microsoft.com/en-us/library/ms175511.aspx

  MJ