Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

How to Create a Corrupt SQL Server Database Expand / Collapse
Author
Message
Posted Monday, May 07, 2012 1:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:59 PM
Points: 5,970, Visits: 12,873
Thanks for your feedback, please don't forget to rate the article to.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1295808
Posted Wednesday, June 27, 2012 6:37 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 21, 2014 8:34 AM
Points: 1,937, Visits: 733
Five stars for me as I find this type of article almost a "reverse engineering" concept, sometimes this can help with the understanding.

Good stuff.

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1321831
Posted Wednesday, June 27, 2012 8:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:59 PM
Points: 5,970, Visits: 12,873
hi thanks for your comments, hope you found it useful
Regards Pez


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1321911
Posted Wednesday, August 22, 2012 6:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:17 AM
Points: 168, Visits: 677
mY database will be corrupted [font="Arial"][/font].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 #1348341
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse