You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?

Question

TuteeHUB · Accepted Answer

NA

TuteeHUB · Answer

Create a database maintenance plan to check database integrity and make repairs each night.

TuteeHUB · Answer

Enable the torn page detection database option for each database.

TuteeHUB · Answer

Disablewrite caching on all disk controllers.

TuteeHUB · Answer

Ensure that write caching disk controllers have battery backups.

1.	You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?
A.	Create a database maintenance plan to check database integrity and make repairs each night.
B.	Enable the torn page detection database option for each database.
C.	Disablewrite caching on all disk controllers.
D.	Ensure that write caching disk controllers have battery backups.
Answer» E.

Discussion

No Comment Found

Related MCQs

Reply to Comment