What should you do?

A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located.
You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do?

A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located.
You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do?

A.
Execute DBCC CHECKFILEGROUP for each filegroup.

B.
Execute DBCC CHECKCATALOG.

C.
Execute DBCC CHECKDB.

D.
Execute DBCC CHECKTABLE for each table.

Explanation:
DBCC CHECKDB will check the logical and physical integrity of all the objects in the specified database by:
– Running DBCC CHECKALLOC on the database.
– Running DBCC CHECKTABLE on every table and view in the database.
– Running DBCC CHECKCATALOG on the database.
– Validating the contents of every indexed view in the database.
– Validating the Service Broker data in the database



Leave a Reply 0

Your email address will not be published. Required fields are marked *