首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
admin
2009-05-19
10
问题
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://kaotiyun.com/show/TuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Inanyrealmoflife-whetheracademic,social,business,orpolitical-theonlywaytosucceedistotalkeapractical,rathe
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Whateverhappenedtothedeathofnewspaper?Ayearagotheendseemednear.Therecessionthreatenedtoremovetheadvertising
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
随机试题
Swan—Ganz管监测
根据居住用地的分类,三类居住用地的特征是()。
按国际标准(ISO6308:1980)石膏墙板推荐宽度为600mm、900mm、1200mm。下列石膏墙板的推荐长度哪组是正确的?[2003—004]
矩形截面挖去一个边长为a的正方形,如图所示,该截面对z轴的惯性矩Iz为:
防止大体积混凝土裂缝的措施有()。
下列哪些选项属于我国中央银行的职责()。
商业银行在使用内部评级法初级法计量信用风险资本时,()不属于合格信用风险缓释工具。
食业期未编制资产负债表时,下列各项应包括在“存货”项目中的有()。
医务社会工作者的个案记录包括哪些内容?()
大数据时代,遍布全球各个角落的传感器等电子设备正在实时获取用户的行为轨迹.名目多样的各类云服务也在不经意间_________用户主动上传信息,数据的攫取越来越公开化、在线化。与此同时,大数据时代的数据获取方式更为_________,往往通过大量数据关联获取
最新回复
(
0
)