Database repair - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Database repair

Author

Topic

William Garrick
Starting Member

1 Post

Posted - 2009-09-30 : 16:33:02

I am trying to fix a SQL Server 2005 database problem that was due to a power outage. The outage left one key table marked as suspect with a 926 error. The wrinkle is that the back-ups are far enough out of date to not be useful

The error logs indicate the problem is do to a torn page. But, all documentation I have found indicates that I should use DBCC CHECKDB to repair the database. But, because of the suspect state of the database, I am not able to use this command.

I am considering using a 3rd party restore application to address the database issue, since I don't seem to be able to do anything from within MSSQL itself. Is there a good MSSQL way to handle this. If not, what is a recommended 3rd party software.

Thanks,

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-09-30 : 17:06:36

Since it's SQL 2005, set the database into Emergency mode first
ALTER DATABASE <DB Name> SET EMERGENCY

Once you've done that you'll be able to get access to the DB. Please run this and post the full output.

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

Depending on the damage it may be repairable without any data loss, repairable with some data loss or not repairable at all. Need to see the output of CheckDB to say anything more.
For more information on corruption, take a look at this article. [url]http://www.sqlservercentral.com/articles/65804/[/url]

--
Gail Shaw
SQL Server MVP

Davidpoul
Starting Member

14 Posts

Posted - 2009-11-11 : 04:01:00

If you are considering for using a 3rd party restore application to address the database issue than i like to suggest you to try sql repair utility. You can download it from http://www.repair-mssql-database.com/download-sql-database-repair-software.php
First try the demo version, if you satisfied with the result than go for full version. But before that i like to suggest you to follow what Mr. GilaMonster suggest.

David Poul
http://www.mssqldatabaserecovery.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources