You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains three Microsoft SQL Server 2005 servers which you administer. The MiracleInfocom .com network includes a mix of databases configured for Full Recovery model and Simple Recover Model. A new MiracleInfocom .com security policy specifies that database servers: 1. All database server should be secured against logon and local access 2. Database servers must be backed up on a predefined schedule 3. Any database should be recoverable to no more than six hours lost 4. The backups must be protected against unauthorized access 5. A copy of the data no more than a week old must be maintained offsite The MiracleInfocom .com network servers are locked in a room with file servers used as the backup destination for all database servers. The Full backups run monthly and the differential backups run nightly. You are required to ensure that all security policy guidelines are met. What should you do?
A. A second file server should be deployed in the locked room and run mirror backups.
B. Transaction log backups must be run every six hours.
C. Mirrored backups should be run to another file server located in a different physical location in the network.
D. The differential backup frequency should be changed to every six hours.
Answer:D
You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains three Microsoft SQL Server 2005 servers which you administer. The MiracleInfocom .com network includes a mix of databases configured for Full Recovery model and Simple Recover Model. A new MiracleInfocom .com security policy specifies that database servers: 1. All database server should be secured against logon and local access 2. Database servers must be backed up on a predefined schedule 3. Any database should be recoverable to no more than six hours lost 4. The backups must be protected against unauthorized access 5. A copy of the data no more than a week old must be maintained offsite The MiracleInfocom .com network servers are locked in a room with file servers used as the backup destination for all database servers. The Full backups run monthly and the differential backups run nightly. You are required to ensure that all security policy guidelines are met. What should you do?
A. A second file server should be deployed in the locked room and run mirror backups. B. Transaction log backups must be run every six hours. C. Mirrored backups should be run to another file server located in a different physical location in the network. D. The differential backup frequency should be changed to every six hours.