Trying to restore a database with STANDBY/READ ONLY

• bubby

  SSCertifiable

  Points: 5638

  More actions

  April 17, 2012 at 12:18 pm

  #254323

  I have this database backed up as test.bak from primary server and want to restore on secondary server as STANDBY/READ ONLY

  Can I be helped so I can issue the commands and restore the database

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 17, 2012 at 12:21 pm

  #1474942

  I recommend reading the following:

  http://msdn.microsoft.com/en-us/library/ms186858.aspx

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 17, 2012 at 12:22 pm

  #1474943

  Please don't start multiple threads for the same problem

  Replies to http://www.sqlservercentral.com/Forums/Topic1284930-1550-1.aspx please

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• bubby

  SSCertifiable

  Points: 5638

  More actions

  April 17, 2012 at 12:23 pm

  #1474944

  OK

• jeysamuel

  Valued Member

  Points: 59

  More actions

  September 25, 2015 at 8:31 am

  #1829488

  Can someone help with script to restore database with Standby/readonly

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 25, 2015 at 9:43 am

  #1829545

  https://msdn.microsoft.com/en-us/library/ms186858.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass