Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, August 25, 2016 2:55 AM
Points: 19, Visits: 79
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: Wednesday, September 23, 2015 3:34 PM
Points: 5,467, Visits: 7,660
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, August 25, 2016 12:45 PM
Points: 8,225, Visits: 16,374
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
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:41 AM
Points: 5,841, Visits: 15,629
Thank you Perry for this nice piece.
Post #1602555
Posted Wednesday, August 13, 2014 12:31 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, August 25, 2016 12:45 PM
Points: 8,225, Visits: 16,374
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