Post reply

Attach Database failed with 9004 error (an error occurred while processing the log for database )

  • November 28, 2007 at 11:49 pm

    #70519

    Hello all,

    A Production database has 14 secondary files divided over 6 filegroups with one single log file.

    This database skipped into Suspected mode .The database was then detached . Now we are not able to attach the same.It shows "Attach Database failed with 9004 error (an error occurred while processing the log for database )" .

    We tried a workaround as

    - Rename the exsisting Data and logfiles.

    - Create an empty database with the same name and physical file layout (file,filegroup structure (irrespective of file size) )

    - Stop the sql services;

    - Swap in the files you want to attach in place of the empty DB files, and start the server

    - Put the db in emergency mode using " UPDATE master..sysdatabases SET status=-32768 WHERE name=' ' "

    - Put the db in single user mode using sp_dboption

    - Run DBCC CHECKDB(dbname,repair_allow_data_loss)

    we are encountering error at the last step as "Could not run BEGIN TRANSACTION in database because the database is in bypass recovery mode "

    Could you please suggest us a alternative workaround so as the database can be brought online.

  • November 29, 2007 at 8:08 am

    #755465

    Does this help: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=598396&SiteID=1

    http://support.microsoft.com/kb/328354

  • November 30, 2007 at 3:36 am

    #755860

    Thanks a ton for the Link provided, but the work around given is the same as we followed. And unfortunately we dint reach the goal of attaching the database

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply