首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
27
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Whileyouwereawayfromhomeonbusinessafewdaysago,yourfatherfellintoacoma.YourneighborMarystoppedacarandbro
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Americanfarmershavebeencomplainingoflaborshortagesforseveralyearsnow.Givenamulti-yeardeclineinillegalimmigrati
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
当今世界正处于百年未有之大变局,但时代的主题仍然是()
两性霉素B去氧胆酸盐快速静脉滴注可导致低血压、低血钾、心律失常和休克,需缓慢避光静脉滴注,每次滴注时间需
Ithink______ofthetextisverydifficult.
高压蒸汽灭菌物品,保存时间不超过
下列是检识黄酮的首选试剂的是
设计方的项目管理工作主要在设计阶段进行,但它也会涉及()。
有关商业银行接管的法律效果,下列表述正确的有()。
蜡烛:教师()
已知一个长度为12的表{Jan,Feb,Mar,Apr,May,June,July,Aug,Sep,Oct,Nov,Dec}:按表中元素的顺序构造一棵平衡二叉树,试求在等概率情况下检索成功的平均检索长度。
Readthetextsfromamagazinearticleinwhichfivewomentalkedabouttheirslimmingfailures.ForQuestions61to65,matcht
最新回复
(
0
)