Recovery of Suspect Database - 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

SQL Server 2000 Forums

SQL Server Administration (2000)

Recovery of Suspect Database

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-11-18 : 08:18:49

kanth writes "Please help me or give some tips about recovering a suspect database...i have checked to resetting the databse status thru isql...but im not able to recover the data bse...matter is bit urgent please help me!

regards

KAN"

nr
SQLTeam MVY

12543 Posts

Posted - 2003-11-18 : 10:26:06

see
http://www.nigelrivett.net/RecoverCorruptDatabase.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

chadmat
The Chadinator

1974 Posts

Posted - 2003-11-18 : 12:01:20

The easiest way is to restore from backup. However, the key to getting a suspect DB back is to find out why it is suspect. You need to look in the Error Log (The one for the first time it came up suspect). There will be an error telling you why it is suspect. Until you know that, there is know sure way to know how to resolve the problem.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.

Glockenspiel
Yak Posting Veteran

50 Posts

Posted - 2003-12-23 : 15:57:48

You might see if detaching and re-attaching it as a single-file db will work.


USE master

EXEC sp_configure 'ALLOW UPDATES', 1

UPDATE master..sysdatabases SET status = 32768 WHERE name = [DBNAME]

RECONFIGURE

USE [DBNAME]

EXEC sp_helpfile

EXEC sp_detach_db [DBNAME]

EXEC sp_attach_single_file_db @dbname = [DBNAME], @physname = [PHYS FILE NAME FOR DATA SEGMENT]

EXEC sp_configure 'ALLOW UPDATES', 0

RECONFIGURE

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources