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 18, 2013 at 4:18 am

    #1624939

    Try This:

    ALTER DATABASE EmpDataBase REBUILD LOG ON (NAME=$DatabaseName$,FILENAME=N'$Path\DatabaseName.ldf$')

    GO

    DBCC CHECKDB

    ALTER DATABASE $DatabaseName$ SET MULTI_USER

    GO