What should you do?

You administer a server that runs SQL Server 2008 Integration Services (SSIS) packages.
The packages are stored on the file system.
You need to integrate the backup and restore processes for the SSIS packages along with the regular SQL Server backup process.
What should you do?

You administer a server that runs SQL Server 2008 Integration Services (SSIS) packages.
The packages are stored on the file system.
You need to integrate the backup and restore processes for the SSIS packages along with the regular SQL Server backup process.
What should you do?

A.
Deploy the packages to SQL Server 2008 and back up the msdb system database.

B.
Deploy the packages to SQL Server 2008 and back up the master system database.

C.
In the ProtectionLevel package property, select the ServerStorage option.

D.
In the ProtectionLevel package property, select the DontSaveSensitive option.

Explanation:
Tip: "" = "msdb"



Leave a Reply 0

Your email address will not be published. Required fields are marked *