PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Execute DBCC CHECKFILEGROUP for each filegroup.

B.
Execute DBCC CHECKCATALOG.

C.
Execute DBCC CHECKDB.

D.
Execute DSCC CHECKTABLE for each table.


Leave a Reply