Database corrupted how to resolve???

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Perry Whittle » Database corrupted how to resolve???

Database corrupted how to resolve???

Rate Topic

Display Mode

Topic Options

Author

Message

Database admin(DBA)

Posted Thursday, August 23, 2012 6:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:18 AM
Points: 154, Visits: 544

mY database will be corrupted .so how to recovery the corrupt database??????( i have little bit confusing.because of iam using below script reocvery the database :

DBCC CHECKDB ('Corrupt2K8') WITH NO_INFOMSGS, ALL_ERRORMSGS
exec sp_resetstatus 'Corrupt2K8'
alter database Corrupt2K8 set emergency
dbcc checkdb('Corrupt2K8')
alter database Corrupt2K8 set single_user with rollback immediate
dbcc checkdb('Corrupt2K8', REPAIR_ALLOW_DATA_LOSS)
alter database Corrupt2K8 set multi_user ))

NOTE: some points for consideration:

Then restore My database from a backup - but make sure to run DBCC CHECKDB on that very backup to ensure it's not corrupt itself.

DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS is the very last resort . Before that, you should restore a valid backup. Once you do use REPAIR_ALLOW_DATA_LOSS, don't expect your database to magically come back to life again - most likely, irreparable damage has occurred - especially in this case since it complains about system table corruption.

Thank you in advance

SQL server DBA

Post #1349069

« Prev Topic | Next Topic »

Permissions