Site Search:

• Exercises Overview
• SQL Server 2000
  • Create Backup Device
  • Database Backup
  • Lost Database - Simple
  • Lost Database - Full
  • Lost Primary - Full
  • Lost Secondary - Full
  • Restore Master
  • Restore MSDB
  • Restore Model, TempDB
  • Attach and Detach DB
  • Point in Time Recovery
  • Using Marks
  • DBCC CHECKDB
  • Verifying Backups
  • Restricted Modes
  • Alter Recovery Model
  • Stored Procs
• SQL Server 2005
• SQL Server 2008 (Late 2008)

Using DBCCCHECKDB in SQL Server 2000 Prior to Performing a Backup

DBCCCHECKDB Ensures the Integrity of Your Database and Should be Used Prior to Backup

• Description
• Requirements
• Setup
• GUI Steps
• T-SQL Steps

Description:

DBCC CHECKDB checks the data integrity of all objects in the database. It should be used before backing up a database to make sure that your database is sound.

(back to top)

Requirements:

None

(back to top)

Setup:

None.

(back to top)

GUI Steps:

None. This is a T-SQL command.

(back to top)

T-SQL Steps:

1) Connect to the Northwind Database and execute the DBCC CHECKDB command. You will get a long stream of output for the objects in the database, then a notification about any errors that may have been found.

 

2) We received the following at the end of the results pane indicating that no errors have been found.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'Northwind'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

(back to top)