Understanding DBCC CHECKDB Command to Deal with Corrupt Database Author: Basit A. Farooq DBCC CHECKDB Overview: Database files are volatile, constantly being changed and updated, so that, like any other volatile files in the system, there is potential for them to become corrupt. Because of this, it is necessary to perform periodic maintenance, to validate the allocation, logical, and structural...
Tag: dbcc checkdb
Troubleshooting problems with DBCC commands in SQL Server 2008 R2
Troubleshooting problems with DBCC commands in SQL Server 2008 R2 If you have problems with SQL Server 2008 R2 DBCC commands, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 DBCC bugs were fixed in SQL Server service packs, you should install the latest SQL...