首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
30
问题
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
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
School-agechildrenshouldparticipatein60minutesormoreofmoderatetovigorousphysicalactivitydaily,accordingtoanex
[A]Enduringproblemssuchaswar,poverty,andviolenceultimatelyspringfromhumannature,whichnotechnologicalinnovation
Writeane-mailofabout100wordstoaforeignteacherinyourcollege,invitinghim/hertobeajudgefortheupcomingEnglish
Supposeyouarethepersonnelmanagerofacompanyandyou’vedecidedtheapplicantnamedZhangWeiisthebestcandidateforth
MenorcaorMajorca?Itisthattimeoftheyearagain.Thebrochuresarepilingupintravelagentswhilenewspapersandmagazin
Faceit,moviefans:theDVDisdestinedtobedeadasadoornail.OnlyafewBlockbusterstoresarestillopen.Netflix’s(o
Google,whichdominatesmuchoflifeontheInternet,hasbeentryingtoexpandbeyondcomputersandtelephonestolivingrooms,
随机试题
下列哪项不是初级卫生保健的基本任务
有关甲状舌管囊肿下面哪一种是不正确的
肺炎患儿宜采取的体位是
A.哌替啶B.喷他佐辛C.美沙酮D.纳洛酮E.吲哚美辛镇痛强度为吗啡的1/10,可代替吗啡使用的药物是
使冠状动脉血流量增多的原因是
位于市区的某国有工业企业利用厂区空地建造写字楼,2009年发生相关业务如下:(1)按照国家有关规定补交土地出让金4000万元,缴纳相关费用160万元:(2)写字楼开发成本3000万元:(3)写字楼开发费用中的利息支出为300万
关于法律责任的说法,正确的是()。
公安机关担负着()等武装性质的任务。
Thetaxidriverwasamaninhislatethirties.Hepickedmeupand【C1】______metomyplace.Iusuallyliketohavebrief【C2】___
Thehousingpriceinbigcitiesis______,butstillmanyyoungpeoplewouldratherbuyahousethanrentaroom.
最新回复
(
0
)