You are the database administrator of a SQL Server 2000 computer. The server contains your company’s Accounts database. Hundreds

admin2009-05-19  36

问题 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 perfect the physical integrity of the Accounts database. You do not want to slow down server operations.
What should you do?

选项 A、Enable the torn page detection database option for each database.
B、Disable write caching on all disk controllers.
C、Ensure that write caching disk controllers have battery backups.
D、Create a database maintenance plan to check database integrity and make repairs each night.

答案C

解析 Explanation: The scenario states that power interruptions have occurred in the past. By buying a battery backup solution for the disk controllers the power interruption problem would be prevented.

Incorrect Answers:
A: Torn page detection is a reactive solution which would slow down performance since restores would have to be made. It would better to use a preventive solution.

Note: Torn page detection: If a torn page is detected, the database must be restored from backup because it will be physically inconsistent.

B: Caching is very import for performance. Disabling write-caching would be a bad idea.

D: Repairing the database every night is not a good solution. Database errors cannot be accepted. It is better to prevent the problem instead of trying to fix it after it has happened.
转载请注明原文地址:https://kaotiyun.com/show/FuhZ777K
0

最新回复(0)