You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services (SSIS) packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task?()
- A、To finish the task,the Products database should be backed up.
- B、To finish the task,your server should be set to utilize the full recovery model.
- C、To finish the task,your server should be set to utilize the bulk-logged recovery model.
- D、To finish the task, the msdb database should be backed up.
微信扫一扫手机做题