DBCC CHECKDB

SQLServerCentral Article

Verify your SQL Server database backups

  • Article

Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]

4.25 (4)

You rated this post out of 5. Change rating

2020-01-07

9,425 reads

External Article

Performing DBCC Checks Using SQL Virtual Restore

  • Article

Ever restored a corrupted database from the backup, only to find that the backups are corrupted too - All the backups? Sure it can happen and it isn't nice when it does. To check that a database backup is internally consistent you have to use DBCC CheckDB. On a huge highly-loaded live system? Grant Fritchey has, as usual, a practical solution.

2011-05-02

3,896 reads

Blogs

Familiar Sights

By

Yesterday was a long day in London. I arrived late in the am, and...

Derby City Data Days

By

It was awesome to see the Kentucky data community come out for the first...

Tomorrow: Webcast on SQL Server security

By

Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...

Read the latest Blogs

Forums

Difference between equal directly and use SUBSTRING

By Martass

Hello, I have a script that was running really long, and I have found...

Visualisation options as an alternative to SanKey diagram

By aaron.reese

I am building a report to show customer journeys and their arrears levels. I...

should i prefer join or left join over exists or in

By rajemessage 14195

hi, I have seen people use exists when exists is required and no cols...

Visit the forum

Question of the Day

Express In-Memory OLTP

Can I create In-Memory OLTP tables in SQL Server Express?

See possible answers