Home Forums SQL Server 2005 Backups RESTORE log shipped database without .TUF RE: RESTORE log shipped database without .TUF

  • 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