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

The Perils of Running Database Repair Expand / Collapse
Author
Message
Posted Monday, June 25, 2012 10:59 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, December 18, 2014 10:51 AM
Points: 1,639, Visits: 1,986
Paul Randal (6/25/2012)
Be careful though because SQL Agent will only capture the first X bytes of the output (unless that changed in recent versions). You may want to go the route of using the undocumented WITH TABLERESULTS and storing the output in a table for later perusal. See here for an example.


We write the output to a file and that has the entire output. Use whichever works better for you.
Post #1320775
Posted Monday, June 25, 2012 1:56 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, November 24, 2014 4:29 PM
Points: 752, Visits: 920
Fantastic article, thank you.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Post #1320869
Posted Wednesday, June 27, 2012 6:10 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:21 AM
Points: 169, Visits: 286
Thanks for this article , all this while in my DBA career was wondering why REPAIR_REBUILD did not work most times on cluster index chain broken.

But observed in one of the client places REPAIR_ALLOW_DATA_LOSS did work for corrupt system tables without data loss but yes backups are best bet's as you said.

Cheers
Satish


Cheer Satish
Post #1321808
Posted Wednesday, June 27, 2012 6:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:15 AM
Points: 2,041, Visits: 1,671
It entirely depends on which system tables are corrupt, and what the corruption is. Basically, it's a crap-shoot whether it'll work or make things worse because the system tables are quite twitchy when direct physical changes are made to them.

Thanks


Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Post #1321812
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse