You work as a database administrator for ABC.com. The ABC.com network contains a SQL
Server 2008 database server named ABC-DB03.
You are in the process of designing a SQL Server 2008 Integration Services (SSIS) package for
the ABC.com network. ABC.com has informed you that ABC-DB03 will be hosting the package.
You receive an instruction from the CIO to devise a plan of action in the event that ABC-DB03
becomes inactive.
How can this be achieved?
A.
The master database should be backed up.
B.
You should back up ABC-DB03.
C.
You should execute an incremental backup on a weekly basis.
D.
The SSIS package should be backed up.