The Curious Case of… missing 832 errors during memory corruption
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
Menu
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
I’m seeing reports from a few people of DBCC CHECKDB reporting PFS corruption after an upgrade from SQL Server 2014 to SQL Server 2016 or
Quite often I see questions about DBCC CHECKDB error messages along the lines of: Specifically, the part that confuses people is “Object ID 0, index ID
This post is about a disaster-recovery scenario I described in our bi-weekly newsletter a couple of weeks ago, and wanted to make sure it’s out on the web too
As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see
As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see
Last week there was a short discussion on Twitter about why PFS pages (damaged header, not individual PFS bytes) can’t be repaired (prompted by a
As Kimberly mentioned last week, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that
An interesting corruption problem cropped up on the MCM distribution list yesterday and after I figured it out, I thought it would make a good
One of the corruptions that can stymie all efforts at disaster recovery is broken boot page. If the boot page can’t be processed, the database
(Check out my Pluralsight online training course: SQL Server: Detecting and Correcting Database Corruption.) This is a question that I was sent over email that
This is a quick blog post to let you know about a bug in SQL Server 2012 SP1 that can cause data loss when performing index maintenance.
Over the last few weeks I’ve been investigating a series of customer corruption issues (on one customer’s system) where it appears that the page checksum
A couple of week ago I kicked off a survey about the extent of your experience with the DBCC WRITEPAGE command. Here are the results:
I’ve just heard from our good friends at Pluralsight that our two latest online training courses are now live and available for watching! My latest
My latest Pluralsight online training course went live today: SQL Server: Detecting and Correcting Database Corruption It’s 4 hours long and is the first in
I originally blogged a series of corruption demos and associated databases back in 2008, for use with SQL Server 2005 and 2008. Since then the
(Check out my online training courses: SQL Server: Detecting and Correcting Database Corruption and SQL Server: Advanced Corruption Recovery Techniques. We can also help you with disaster recovery.) Yesterday on
A few days ago one of my new blog readers (a pretty smart cookie, as you'll see) sent me a tale of database catastrophe and
The May edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
The very worst piece of advice I ever saw on the Internet was in response to someone asking on a SQL newsgroup ‘how can I
A couple of years ago I blogged about 3rd-party file system filter drivers and how if they're not coded correctly to cope with NTFS alternate
2005 SP3 CU6 contains a fix for a corruption bug that can happen after rebuilding an XML index that contains XML elements greater than 8000
I was reading a thread on SQL Server Central today where someone replied to a question and confused 823 with 832. Now, 823 is a
Here’s a question that came up recently: if I’ve upgraded a database from SQL 2000 or before, how can I tell if the data purity
The August edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
In this week's survey I'd like to know how often you run consistency checks on your *most critical* production database, regardless of *how* you run
This week's been a busy one on the forums and Twitter, with lots of interesting problems people are hitting. One of the things I've noticed
This is a true story, and unfolded over the last few days. It’s deliberately written this way, I’m not trying to be patronizing – just illustrating
This has come up a few times now, most recently in an email question this morning – subsequent runs of DBCC CHECKDB show varying numbers of
Not much to do here in Tokyo while waiting for the Bangkok flight except read and blog, and I've already done enough reading for one
Just saw this on a forum – running REPAIR_ALLOW_DATA_LOSS on msdb to cope with corruption. Yes, this will work but it's certainly not safe and
(Yes, Kimberly's lecturing again…) Here's something that I've seen crop up a lot recently on corruption forums: Server: Msg 602, Level 21, State 50, Line
A thread cropped up on SQLServerCentral involving IAM chain corruption (see Inside the Storage Engine: IAM pages, IAM chains, and allocation units for details of IAM
The April edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
Both 2005 SP3 CU2 and 2005 SP2 CU12 contain fixes for two bugs that cause corruption in LOB data. The first bug may happen when
This is an interesting case that cropped up yesterday – the transaction log is damaged so a log backup doesn’t work (with the error below):
There are two pretty well-known I/O errors – 823, and 824 – but there’s also one called 825 which most DBAs do*not* know about, and
In SQL Server 2000 and before, the symptoms of database corruption would occasionally manifest themselves as asserts, such as: SQL Server Assertion: File: <recbase.cpp>, line=1378
Well, we're back from vacation finally (only for 10 days and then off to India and Thailand for 3 weeks… phew) and I've got a
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.