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 «««123

How to Create a Corrupt SQL Server Database Expand / Collapse
Author
Message
Posted Friday, August 8, 2014 10:01 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 21, 2015 8:36 AM
Points: 8, Visits: 42
I haven't seen the PAGE command used for a really useful DBA purpose in a very long time. I've used it for educational purposes, for myself and also to give Dev folks an appreciation of what is going on under the covers. I like it. If you do any FMEA (Look it up, "Failure Mode Effects Analysis"), this tip can be really helpful. Nice.


Post #1601252
Posted Friday, August 8, 2014 10:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 8, 2014 10:16 AM
Points: 19, Visits: 60
Hi Perry
The last image of the post says
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB
Post #1601264
Posted Friday, August 8, 2014 2:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, March 12, 2015 6:11 PM
Points: 5,467, Visits: 7,659
Nice article Perry. Simple and effective techniques. Thank you.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1601333
Posted Friday, August 8, 2014 3:11 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, April 24, 2015 8:16 AM
Points: 7,163, Visits: 15,084
roberto.regidor (8/8/2014)
Hi Perry
The last image of the post says
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB

Yes it clearly is incorrect in this case


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1601339
Posted Tuesday, August 12, 2014 10:22 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 3,507, Visits: 9,375
Thank you Perry for this nice piece.
Post #1602555
Posted Wednesday, August 13, 2014 12:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, April 24, 2015 8:16 AM
Points: 7,163, Visits: 15,084
You're welcome

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1602579
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse