Integrity checks, corruption findings, and database integrity incidents.
29 associated posts26 primary posts
There's an old DBA saying...
May you already have a backup restored
A half hour before your boss knows there's corruption
What? There's no such thing as old DBA sayings? Well, maybe if you all said something other than "no" once in a while, you'd be more quotable. Hmpf.
Anyway, this is a serious question! And there are a lot of things to consider
whether it's a new job or a new (old) server
If you're reading this, you've at some point in your career stared at a server, for the first time, with great trepidation.
If you've got indexed views, or are thinking of using them, this is important.
First, go read the blog post, "An Indexed View Bug with Scalar Aggregates" by Paul White. It will take a minute, but it's important to understand.
DBCC CheckDB: Frequently Asked Questions
Q: Do I really need to run DBCC CheckDB? Yes. If you're even partially in charge of a SQL Server and you'd like to keep your job, you should make sure CheckDB is being run regularly. (Seriously!)
The latest version of sp_Blitz® alerts you if you haven't been using the WITH CHECKSUM parameter on your backups. This parameter tells SQL Server to check the checksums on each page and alert if there's corruption. But what about corrupt backups? Books Online says: NO_CHECKSUM - Explicitly disables the generation of backup checksums (and the validation…
Taking care of your health is incredibly important (says the marathon runner). Eating right, exercising, and getting plenty of rest help you stay healthy and perform optimally. Your database server’s health is important to your company’s health. You need to take regular backups, check for consistency, and keep indexes tuned for optimal performance. Here are…
I recently posed the question, “Who’s taking your backups?” This is of utmost importance, because your business’s data is the business. Protecting it and backing it up need to be priorities for DBAs.
Now, for my next question: who is responsible for restoring those backups?
With SQL Server 2012's new AlwaysOn Availability Groups, we have the ability to run queries, backups, and even DBCCs on database replicas. But should we? Paul Randal (Blog - @PaulRandal) covered this issue in today's SQLskills Insider newsletter, and he says: "It’s not checking the I/O subsystem of the log shipping primary database – only…
In the final part of my SQL University serries, I talk about the nightmares of storage: why things change when we're not looking and why virtualization makes it harder to keep an eye on things.
