You are the consultant of a CPA firm.
You install Microsoft Windows Small Business Server 2003 on a network server. The network contains 15 client computers that run Microsoft Windows XP Professional. You install the firm’s accounting application that uses Microsoft SQL 2000 Server on a member server that runs Microsoft Windows Server 2003. The accounting application is running all of the time. You install a tape drive on the member server for system backups.
You need to create a backup plan that performs database backups and transaction log backups of the accounting application’s databases. You need to create separate weekday and weekend schedules for each of these backups.
You need a backup plan that requires the least amount of administrative effort.
What should you do?
A.
Create a backup by using the Windows Small Business Server 2003 Backup wizard tool.
B.
Create a backup of the drive that contains the SQL databases by using the Backup wizard.
C.
Create a database maintenance plan on the member server that backs up the databases and the logs as a single maintenance plan.
D.
Create a database maintenance plan on the Windows Small Business Server 2003 computer that backs up the databases and the logs as a single maintenance plan.