We just had a hard drive crash here. We were able to copy off the .mdf file from SQL server 2000 from the drive, but not the .ldf (which was only 720k anyhow).
When I try to attach the mdf to an SQL Server 2000 or 2005 server I get an error saying that the log file doesn't exist.
Does anyone know a way to attach this not-cleanly-closed database file and recover the data? (apparently the person decided that they need-not backup their database :<)
Thanks for any help you can provide!
You may get lucky and be able to attach to a SQL 2005 instance and use the ATTACH_REBUILD_LOG clause...try something like this:
create database <x> on <filespec> for attach_rebuild_log
|||Thanks. I tried that, but it said the same thing, and the documentation says that you have to have a cleanly shut down database to be able to use that command.
Thanks anyways! Any other ideas?
|||I got the same problem and the sames answers from 2000 and 2005. Any idea will help me too.|||This has to go back to your backups. Do you have full/differential/log backups? What's your disk architecture?|||I posted too fast...didn't get to read that you do not have backups...I have another question...did the entire server go down or only the disk?|||The whole drive failed. I was able to freeze it and get the mdf, but the log file was corrupt.Hence i have an mdf and no log file that will work, and the idiot that owned the machine didn't do a backup.
No comments:
Post a Comment