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