Just received question from one of the DBA
Question: I do not have full backup of my database. My .mdf and .ldf are corrupted. Is there any way I can restore database now?
Answer: Sorry. I do not think there is any way you can do it. Try attaching this files to database using db_attach but if that does not work, it will be very difficult make it work.
If any of blog reader know fix for this, please post here.
Reference : Pinal Dave (http://www.SQLAuthority.com)
pinaldave
Very difficult, but I have found the following can sometimes work:
alter database test
set emergency
go
alter database test
set single_user
go
dbcc checkdb (test, repair_allow_data_loss)
alter database test
set multi_user
go
Hope this helps
dvc
[...] 10, 2008 by pinaldave Blog reader Donald Crowther has posted following comment. I have not tested this solution and when I tried to test it, it did [...]
Recommend use this tool-fix mdf,as far as i know it is free and has many other features,utility can repair data from corrupted databases in the MS SQL Server format (files with the *.mdf extension),supports data extraction via the local area network,can save recovered data as SQL scripts, it is also possible to split data into files of any size,compatible with all supported versions of Microsoft Windows, such as Windows 98, Windows Me, Windows NT 4.0, Windows 2000, Windows XP, Windows XP SP2, Windows 2003 Server, Windows Vista,tool supports the following database formats: Microsoft SQL Server 7.0, 2000, 2005,also can repair .mdf files of Microsoft SQL Server 2005, repair mdf file of Microsoft SQL Server 2005 (64-bit).