《sql管理》ppt课件

《《sql管理》ppt课件》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Module5:执行管理任务概述配置任务例行SQLServer管理任务自动化例行管理任务创建警告SQLServer自动化排错自动化多SERVER作业配置任务配置SQLServer代理配置SQLAgentMail和SQLMail配置链接服务器设置数据源名字配置SQLServer在IIS中对XML的支持配置和其他服务器应用共享内存配置SQLServer代理SQLServerAgentMustBeRunningatAllTimesConfigureSQLServerAgenttoautostartConfigureSQLServerandSQLServerAgentservicestorestart

2、automaticallyiftheseservicesstopunexpectedlyTheSQLServerAgentLogonAccountMustBeMappedtosysadminRoleMapthisaccounttotheAdministratorslocalgroupUseaWindowsdomainuseraccountlogonaccountUseWindowsAuthenticationModeforSQLServerAgent配置SQLAgentMail和SQLMailSQLServerSQLMail(SQLServerService)Executesthexp_se

3、ndmailextendedstoredprocedureSQLAgentMail(SQLServerAgentService)Sendsjobandalertnotifications配置链接服务器SQLServerOLEDBProviderFilesystemOLEDBProviderSQLServer设置数据源名字ADataSourceNameDefinesODBCdrivertouseConnectioninformation(includingnameandlocationofdatasource,loginaccount,andpassword)Driver-specificop

4、tionsfortheconnection配置SQLServer在IIS中对XML的支持ISAPIFilterInternetInformationServicesUsesISAPIFilter(SQLXML.DLL)andtheOLEDBProviderHTTPRequestSQLServerIISOLEDBXML配置和其他服务器应用共享内存ConfiguringtheMemoryOptionsminservermemorymaxservermemoryDeterminingMaximumAmountofMemoryUsingWindows2000SystemMonitortoObserve

5、Effects例题54.YouwanttoconfigureSQLServertonotifyyoubye-mailwhenanalertoccurs.Whichseriesofstepsmustyouperform?A.ConfiguretheSQLServerAgentservicetologonasthelocalsystemaccount.LogontotheserverrunningSQLServerasyouruseraccount,andconfiguree-mailconnectivity.ConfiguretheSQLServerAgentservicetousetheres

6、ultinge-mailprofile.B.ConfiguretheSQLServerAgentservicetologonasadomainuseraccount.LogontotheserverrunningSQLServerastheSQLServerAgentaccount,andconfiguree-mailconnectivity.ConfiguretheSQLServerAgentservicetousetheresultinge-mailprofile.C.ConfiguretheMSSQLServerservicetologonasadomainuseraccount.Log

7、ontotheserverrunningSQLServerastheSQLServeraccount,andconfiguree-mailconnectivity.ConfigureSQLMailtousetheresultinge-mailprofile.D.ConfiguretheMSSQLServerservicetologonasadomainuseraccount.Logontothes