PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are a database administrator for AIOTestKing.com. Your SQL Server 2005 computer contains a user database named Products. You use SQL Server Integration Services (SSIS) packages to export data from the Products database to a text file. You use FTP to send the text file to your company’s trading partners. You need to ensure that you can recover your SSIS packages if a disaster occurs. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Back up the Products database.

B.
Back up the msdb database.

C.
Configure your server to use the full recovery model.

D.
Configure your server to use the bulk-logged recovery model.

Explanation:
The msdb database is used by SQL Server, SQL Server Management Studio, and SQL Server Agent to store data, including scheduling information and backup and restore history information.


Leave a Reply