2. 计算机
  3. server’s msdb database in an e-mail message to the administrator of another SQL Server computer. You create a job that contains

server’s msdb database in an e-mail message to the administrator of another SQL Server computer. You create a job that contains

admin2009-05-19  14
问题 server’s msdb database in an e-mail message to the administrator of another SQL Server computer.
You create a job that contains the following steps:
--Detach the msdb database
--Send the database to the administrator in an e-mail message
--Reattach the msdb database

You test the job, and it fails on the first step. You need to ensure that the msdb database is mailed to the administrator every night.
What should you do?
选项 A、Ensure that the SQLServerAgent service is running under a user account that has database owner access to the msdb database
B、Delete the first and last steps in the job
C、Configure the job to back up the msdb database to a temporary file. Send the file to the administrator in an e-mail message
D、Insert a new job step before the first step. Configure the new step to terminate all processes that use the msdb database
答案C
解析 Explanation: The current job fails since the detach msdb statement fails. It fails because detaching a database requires that no one is using the database. The msdb database is used by the SQL Server Agent service, which performs scheduled activities such as backups and replication tasks. We want to send the msdb database. The msdb database could be detached if all processes that use it where terminated. Then we could send the database file and reattach the msdb database. This would stop scheduled tasks from being run during this period. A better approach would to be to backup the database and send the temporary file instead.

Note: A new SQL Server 2000 installation automatically includes six databases: master, model, tempdb, pubs, Northwind, and msdb. The master, model, and tempdb databases cannot be detached.

Incorrect answers:
A: The problem that the SQL Service Agent is using the msdb database. This problem would still be there even user account running the SQL Server Agent service is changed.

B: The msdb database is used by the SQL Server Agent service and the database file would be locked. It cannot be sent directly in an e-mail message.

D: The msdb database could be detached if all processes that use it where terminated. Then we could send the database file and reattach the msdb database. This would stop scheduled tasks from being run during this period.
转载请注明原文地址:https://jikaoti.com/ti/xwO7FFFM
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)