RESTORE log shipped database without .TUF

• rchantler

  SSCrazy

  Points: 2128

  More actions

  May 19, 2010 at 11:09 am

  #232671

  Is there a way to change the state of a log-shipped database from (Standby/Read-Only) to recovered if the .TUF file is missing? We can brute force copy the data but we're guessing there is a better way.

  Thanks for any help.

• marcusklemp

  Grasshopper

  Points: 17

  More actions

  May 26, 2015 at 2:43 pm

  #1800704

  1. Stop SQL

  2. Rename database mdf and ldf

  3. Start SQL

  4. Drop In Recovery database

  5. Create database with the same name, same mdf, and same ldf

  6. Stop SQL

  7. Delete new mdf and ldf

  8. Rename mdf and ldf back to their original name

  9. Start SQL

  Should work now.

  Marcus

• rchantler

  SSCrazy

  Points: 2128

  More actions

  June 1, 2015 at 8:18 am

  #1802002

  Thanks.