Occasionally you may want to run DBCC CheckDB against all of the databases on your SQL Server. Hopefully you have a job to run checkdB regularly, but in case you just want to check to confirm that you have no corruption on all of your databases right now you can use this script. Once you run the script copy …
Quick script to run DBCC CheckDB for all of your databases Read more »
This week I completed another successful corruption repair. Here is what the client had to say when the database was repaired: Stedman Solutions were no less than amazing! We were in a major bind; we had corruption in a SQL Database and all kinds of finger pointing from my software and hardware vendors. From one of my vendors “ …
You have a DBCC CHECKDB script running, something like the following, and it may take several hours to run to confirm if there is any corruption in your SQL Server Database. Then someone asks you the age old question… When will it be done? You look at the window running the command and you can see how long it …
DBCC CheckDB or CheckTable – Find percent complete Read more »
This weekend the Stedman Solutions team had the opportunity to help a new client repair their corrupt database. By Sunday evening we had their database completely recovered and up and running. I certainly didn’t get enough sleep over the weekend, and I think that I may have set a personal record for the longest Webex session that I have participated …
If you know me, you will know that I really enjoy working on and fixing database corruption, as well as working on SQL Server internals, specifically relating to corruption and page formats. This week a question came up on the #sqlhelp hashtag on Twitter around corruption in a BLOB page. Elizabeth Hunt was nice enough to send it my way, …
#SQLHELP and a mention on Knee Deep in Tech podcast Read more »
The question came up as how to find a link from blog storage that is corrupt back to the table and row that contains that data. The is no link from the blob storage back to the table and row, but this is a link from the data page containing the table and row off to the blob data. …
The REPAIR_ALLOW_DATA_LOSS option for DBCC CHECKDB and DBCC CHECKTABLE can be one of the most misleading and possibly catastrophic options. What the REPAIR_ALLOW_DATA_LOSS option does for DBCC CHECKDB and DBCC CHECKTABLE is to simply just throw away any pages (8k blocks of data) that contain rows. This may mean it is throwing away a couple of rows, or dozens to …
I am excited to announce that 2 of the sessions that I proposed for PASS Summit 2017 have been accepted. This is the first year that I have had 2 sessions accepted for Summit, and I am looking forward to it. The two sessions are: Basics of Database Corruption Repair Your database is running fine month after month with no …
On March 18th I will be attending SQL Saturday 610 in Richmond Virginia and the day before I will be presenting a pre conference session covering half a day on Database Corruption and half a day on Disaster Recovery Planning. This event has just been announced, and you can sign up for the pre-con session now. I will be presenting with …
Pre-con at SQL Saturday Richmond in March – Emergency Preparation for Database Disasters Read more »
One of those services that I offer is on call help for DBA’s who encounter database corruption. Call me anytime 24/7 and as long as you are an existing customer, or we can work out a billing arrangement to turn you into a paying customer, I can help. That’s all a good if you are familiar with what database …