3 Ways to Run DBCC CHECKDB Faster

In my last post, I talked about how you can get 43%-67% faster backups. This time, I’m using that same SQL Server setup to discuss how throwing more CPU cores might help you check for corruption faster if you’ve already got modern fast storage.

Can I Offload DBCC CHECKDB To Another Server?

You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m not talking about doing corruption checking on both the primary and other servers – that’s wonderful, and if you’re doing that, you should hug yourself. You’re doing a good job. Who’s a good dog? You are! Good dog.

SQL Server Timeouts During Backups and CHECKDB

So you’re hosting your SQL Server in the cloud, and you’ve noticed that when you’re running a backup or a DBCC CHECKDB, you suffer from extreme performance problems - what's going on? Brent Ozar explains.

DB Integrity & Backup Report

This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.

Log Shipping Lite with PowerShell

A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.

T-SQL Restore Script Generator

A procedure that generates point in time restore database & log commands for your databases.

How to Create a Corrupt SQL Server Database

This article details how to create a corrupt SQL Server database for testing purposes

Recovering data from corrupt tables using non-clustered indexes

At times database corruption happens and no good recovery path is available. It is possible to salvage data from indexes using query hints.

CheckDB

RE: urgent please

declare @record_code char(2) select * from record001 where record_code not in ('00','01','02','03','04') if(@record_code='00') begin  insert into record0  select * from record001   where agency is null   or trans_id is null   or ISNUMERIC(trans_id)=0   or isnumeric(accounts_trans)=0   or isnumeric(baccounts)=0   or isnumeric(daccounts)=0   or isnumeric(osa)=0 delete record001  where agency is null   or trans_id is null   or ISNUMERIC(trans_id)=0   or isnumeric(accounts_trans)=0   or isnumeric(baccounts)=0   or isnumeric(daccounts)=0 […]