September 8, 2008 at 11:24 pm
Dear Sir,
Hi Every body, I am in front of a big problem, I have a client whcih database is suspected I can't recover the database when i want to attach the database there is a problem giving and trying to delete the .mdf file but i can't delete it. So what i do i can't think up. I have a backup of the database but the backup is not upto-date so If I take old backup may I lose huge data.
Therefore If you any solution please help me. Here I am attaching two files which you can see the problems.
Thanking You
Debasis Bag
September 9, 2008 at 12:12 am
Hello,
As you don’t have a recent backup you could attempt the recovery process described in this article:-
http://www.codeproject.com/KB/reporting-services/SQL_2005_Suspect_Database.aspx
The following article gives more general advice on handling Suspect DBs;-
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
September 9, 2008 at 12:42 am
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
September 9, 2008 at 12:52 am
Paul,
Somewhere I read like... We can change that database to emergency mode and restart the server so that it wont look for LOG files and then build a new log file to the same path by renaming the existing LOG file and now reset the database status and restart the server you will get database back to normal state with minimal data loss...
Your thought about this?
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
September 9, 2008 at 1:32 am
Read the blog post - it explains all about emergency mode and emergency mode repair. Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply