SQLChicken.com

SQL Server DBA Tips & Tricks

By

Got Corruption?

So today I’ve been dealing with one hellacious case of database corruption and thanks to the beauty of social networking I was able to get help from SQL Jedi-master Paul Randal. I’ll post my entire in an upcoming post but just wanted to share a new trick I learned. Paul posted an article tonight (thanks to my situation) about how to get back all the errors generated by your corrupted database via DBCC CHECKDB if you have more than 1,000 errors. This method involves using the osql utility. Go check out his article and stay tuned for the thrilling saga of what NOT to do with a database.

Share

One Response to Got Corruption?

  1. Dan Shargel says:

    Interesting, thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">