Home Forums SQL Server 2008 SQL Server 2008 - General .ldf deleted and now cant attach database RE: .ldf deleted and now cant attach database

  • June 19, 2013 at 5:44 am

    #1625411

    GilaMonster (1/11/2012)

    Perry Whittle (1/11/2012)

    To re attach a database with a missing log file just use either

    sp_attach_single_file_db

    CREATE DATABASE .... FOR ATTACH_REBUILD_LOG

    Which only works if the database was shut down cleanly before the log was deleted, not in all cases.

    .....and afterwards run a CHECKDB to ensure that the database is consistent and that its integrity hasn't been compromised.