Exit 70-447 UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005
Question 4 of 5
0% complete
Q4 Single choice

You are a database administrator for your company. 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?

  • 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.

Previous Next