September 12, 2003 at 10:11 am
WE HAVE A BIG PROBLEM
our server crashed and we have restored bad data. Tryin to attach a Database we have a 9004 message (bad Log file).. how can we restore the data in our .mdf
Thx for any type of help you can give!!!
Thx a lot
September 12, 2003 at 10:20 am
Do you not have a backup that works?
Try attaching the MDF without the log file (rename it) and let the system recreate it.
If that doesn't work and you are really stuck and need help, burn the $250 and call MS PSS.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 12, 2003 at 11:32 am
To do what Steve suggests...
Rename and move the .log file
In Enterprise Manager,
Click on Databases, select Attach Database. Browse to the proper .mdf file and select that. Continue with the wizard.
In Query Analyzer,
Use sp_attach_single_file_db 'databasename'
Refer to the Books OnLine for more information.
-SQLBill
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply