You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Orders. Several data capturers enter data into the CK_Orders database everyday.
Domain.com wants you to implement a disaster recovery plan for the CK_Orders database. You need to ensure that data can be easily recovered. You plan to perform a full backup every Saturday at 2:00 P.M.
What should you do?
A.
Open the Windows Backup utility on Certkiller -DB01. Configure a Full backup to run weekly on Saturdays at 2:00 P.M.
B.
Run the BACKUP DATABASE Transact-SQL statement on the CK_Orders database.
C.
Open the Database Backup dialog box fro the CK_Orders database in the SQL Enterprise Manager console. Configure a Full backup to run weekly on Saturdays at 2:00
D.
Open the Database Backup dialog box fro the CK_Orders database in SQL Management Studio. Configure a Full backup to run weekly on Saturdays at 2:00 P.M.
E.
Explanation:
You configure a Full backup of a database in SQL Management Studio. You can accomplish this by right-clicking the appropriate database and selecting Tasks and then Back Up from the context menu.
Incorrect Answers:
A: The Windows Utility can be used to backup data on a computer. It cannot be used to backup a database.
B: The BACKUP DATABASE statement can be used to backup a database but it cannot be used to schedule a recurring backup job.
C: SQL Server 2005 dos not support the SQL Enterprise Manager console. SQL Server 2005 uses the SQL Management Studio.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: database backups [SQL Server] Microsoft SQL Server 2005 Books Online (2006), Index: BACKUP DATABASE statement