Restoring last file with NoRecovery

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  August 29, 2002 at 8:35 am

  #173329

  I am investigating restoring issues and have on purpose restored the last log using NORECOVERY. I know there is a simple way to change the database to a recovered state because I saw it in a newsgroup last year - unfortunately I can't find the URL and can't see an obvious option for this. Anyone got the solution?

  Paul Ibison

  Paul.Ibison@blueyonder.co.uk

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  August 29, 2002 at 8:42 am

  #435653

  Try this out....

  RESTORE DATABASE <yourdatbase> WITH RECOVERY

  -------------------------

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  August 29, 2002 at 10:43 am

  #435676

  Thanks Gregory - will try it out tomorrow morning.

  Paul Ibison

  Paul.Ibison@blueyonder.co.uk

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  September 2, 2002 at 5:25 am

  #435793

  Excellent - it works!

  Paul Ibison

  Paul.Ibison@blueyonder.co.uk

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com