What should you back up?

You work for an organization with global operations. You are responsible for the SQL Server
2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and
weekly feeds.
These packages are deployed via the SQL Server method.
The servers reside in geographies with a high risk of natural disaster.
You need to implement a disaster recovery plan to back up the SSIS packages for
availability.
What should you back up?

You work for an organization with global operations. You are responsible for the SQL Server
2008 Integration Services (SSIS) instance. You develop SSIS packages to load daily and
weekly feeds.
These packages are deployed via the SQL Server method.
The servers reside in geographies with a high risk of natural disaster.
You need to implement a disaster recovery plan to back up the SSIS packages for
availability.
What should you back up?

A.
The model database

B.
The package folder

C.
The master database

D.
The MSDB database

Explanation:



Leave a Reply 0

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