Attach database failed error 9004

You have two options:

1. You can create an empty database with the same name and physical file layout, shut down the server, swap in the files you want to attach in place of the empty DB files, and start the server. The database should come up in suspect mode. You can then ALTER DATABASE <foo> SET EMERGENCY to put it in emergency mode, and then run DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS. This will pull as much data as possible out of the log to make the database consistent, but may have to delete some data in order to make the database consistent. This is the option which is most likely to get the maximum data back.
2. You can attempt to use the CREATE DATABASE FOR ATTACH_REBUILD_LOG to see if that will bring it back. If the database was cleanly shut down, you MIGHT be able to succeed. There is also the chance that the database will be inconsistent or corrupt if there are transactions which could not be rolled back. You should in any event run DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS to make your database consistent. In this event, SQL Server will make no attempt to mine information from the log. It will ignore the contents of the log. If there were transactions in process no rollback will be possible, so the ALLOW_DATA_LOSS will be required.

KevinFarlee at 2007-8-30 >

Dear Kevin,

i want to thank you very much for your help... the db is ok now...

Best regards

Gigi

Gigi69 at 2007-8-30 >

I have these exact problem but on sql server 2000.

client was not backing up databases and after a power glitch, there is disk corruption - all the files are on the file system but I cannot start the instance

i tried to attach any of the user database files to another instance on another box and get the same error

Error: 9004 An error occurred while processing the log for database

Now, databases were in full recovery mode, no backups ... please advice

sql server 2000 sp4

maiko at 2007-8-30 >

hi maiko,

the solution that i used to solve my proble was:

- create a new db with the same name of the lost db;

- put the db in emergency mode;

- stop sql service and replace the mdf file;

- start sql service;

- the db is probably corrupted for the disk crash...and you have to reindex all table.

bye

Gigi

Gigi69 at 2007-8-30 >