I have managed to restore the DB from a very old backup, and I tried replacing the MDF and LDF files with the ones that I recovered from a backup.  The problem is that the new MDF and LDF files were not detached in the copy that I have, so when I start up the SQL server EM shows the DB as Loading/Suspect.  I have tried restoring the database using sp_attach_db, sp_attach_single_file_db.  I get the error The log for database DBName is corrupt' when I use sp_attach_db, and when I use sp_attach_single_file_db I get the error 'Database 'DBName' cannot be opened because some of the files could not be activated'

What can I do?  Can a database be restored from an MDF file that wasn't de-attached first?
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



Hi..U can get info here:


· Click the Windows "Start" button and enter "cmd"into the text box. Press "Enter" to open your command line utility.

·  Type thefollowing command into the command prompt and press "Enter":

cd C:\Program Files\Microsoft SQL Server\100\SetupBootstrap\Release

This points the command prompt to the location of therebuild executable files.

·   Type thefollowing text into the command line and press "Enter":

Setup.Exe /Action=RebuildDatabase/InstanceName=MSSQLSERVER /SqlSysAdminAccounts=Admin

This command rebuilds the database. It may takeseveral minutes to complete. Once it is finished, the command line returns asuccess message.


Answered 12/01/2014 by: smol45
White Belt

Please log in to comment