DBCC CHECKDB

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)

2020-01-07

8,056 reads

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

Daily Coping 21 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

#PowershellBasics: Bulk insert.

By

In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...

Lambda Architecture in data systems and possible meaning of this name

By

(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...

Read the latest Blogs

Forums

Difference between SaaS and web application?

By milowbrac

I'm currently interested in self-hosting and I recognized that mostly it's about alternatives for...

Reducing Temp Table Scans when joining two temp tables using OR conditions

By scarr030

Hi all. I have also posted this on DBA Stack Exchange, but I'm posting...

question about username dbo

By cphite

I have been asked to revoke access from a few developers in SQL Server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers