You work as a database administrator for The 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 network. 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?

1)The master database should be backed up.

2)You should back up ABC-DB03.

3)You should execute an incremental backup on a weekly basis.

4)The SSIS package should be backed up.

  • : 293
  • : 1
    Previous Next

    The master database should be backed up.

    Suggest other answer
    Login to Discuss/suggest the answer...

  • Exam: 70-448 MS SQL Server 2008, Business Intelligence

    Recommended Learning for you

    Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material