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: Yesterday @ 5:25 PM
Points: 7,375, Visits: 15,375
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
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 5:06 AM
Points: 4,038, Visits: 10,411
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: Yesterday @ 5:25 PM
Points: 7,375, Visits: 15,375
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