You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
There is a SQL Server 2008 instance. Now you are in charge of SQL Server 2008 Integration Services (SSIS) on this instance.
Now you get an order from your company, according to the company requirement, a failure recovery plan has to be created for packages that are deployed to a SQL Server.
As the IT support, you have to accomplish this task. So what action should be performed?
A.
You should perform the backup of the model database
B.
You should perform the backup of the MSDB database.
C.
You should perform the backup of the tempdb databse
D.
You should perform the backup of the master database
the answer to this question is B, as the question is asking you to backup up the packages after they have been deployed to SQL Server.
the explanation for the answer to this question is as follows:
When packages are deployed to the SQL Server they are stored in the msdb database.
The SQL Server tempdb and masterdb do not include SSIS package information