试题详情
- 单项选择题 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.
- D
关注下方微信公众号，在线模考后查看
热门试题
- Your network contai
- Youattempttoupgradea
- Your network&e
- You are the network
- 你有一个包含几个终端服务器的终端服务场。
- Four Windows Communi
- You need
- You are a
- Ten users&ensp
- You are t
- Your portable&
- You use Microsoft .
- You are the network
- You need to turn on
- You have a server t
- Your company&e
- You need
- 你是Fabrikam.Inc公司网络管理
- You have
- Your network&e