DB Snapshot getting created with Trustworthy property of 1.

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  April 16, 2008 at 1:59 am

  #181406

  I have a database been mirrored from another server. I am creating a database snapshot from this mirrored db. Trustworthy property is 0 in my mirrored DB. But when I am creating a snapshot of the mirrored DB,

  Trustworthy property is having a value of 1.

  I need to have the trustworthy property of snapshot db to be same as mirror db (which should be 0).

  Please suggest some ways.

  Thanks,

  Kishore.

• dbaker-620086

  SSCrazy

  Points: 2336

  More actions

  April 16, 2008 at 8:45 am

  #803129

  BOL shows you the syntax for SQL2005, SQL2008

  http://msdn2.microsoft.com/en-us/library/ms174269.aspx

  http://msdn2.microsoft.com/en-us/library/bb522682(SQL.100).aspx

  so you should try command like

  ALTER mydbcopy TRUSTWORTHY OFF

  new db gets cloned from model so you should change model to have appropriate parameters

  - and get rid of the irritating autogrow data=+1MB unlimited, tlog=+10% 2TB max !

  HTH

  Dick

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  April 16, 2008 at 9:51 am

  #803188

  SQL does not allow to use "Alter database" on a snapshot db.