none
Error 9004: an error occurred while processing the log for database

    General discussion

  • I am using SQL-Server 2000 . when i try to attach the mdf file it gives error message Error 9004: an error occurred while processing the log for database . please help  me out..
    Wednesday, July 24, 2013 4:45 AM

All replies

  • Refer this url.

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/48cf82c9-2179-46f3-b009-11416a90d248/attach-database-failed-error-9004


    Srinivasan

    Wednesday, July 24, 2013 4:55 AM
  • Its a known issue ...try below:

    Create an empty SQL server database with same name & layout.
    Now shutdown the services of SQL server.
    Move the database file into newly created empty database file that you want to attach.
    Start the SQL server database.
    Probably, your database will go in suspect mode.
    Now ALTER your database and set database in emergency mode.
    Run DBCC CHECKDB command on your database with and repair clause, It will give you a repair clause and again run DBCC CHECKDB with repair_allow_data_loss. You will probably loose some data or records of your SQL server database.

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Wednesday, July 24, 2013 1:23 PM
  • Thursday, July 25, 2013 6:16 AM