sql管理ppt課件(參考版)
2025-01-12 05:17本頁面
【正文】 Retry attempts: 2 Fail? Job Step 1: Back Up Database Type: TransactSQL。Module 5: 執(zhí)行管理任務(wù) 概述 ? 配置任務(wù) ? 例行 SQL Server管理任務(wù) ? 自動(dòng)化例行管理任務(wù) ? 創(chuàng)建警告 ? SQL Server 自動(dòng)化排錯(cuò) ? 自動(dòng)化多 SERVER作業(yè) ?配置任務(wù) ? 配置 SQL Server代理 ? 配置 SQLAgentMail 和 SQL Mail ? 配置鏈接服務(wù)器 ? 設(shè)置數(shù)據(jù)源名字 ? 配置 SQL Server在 IIS中對(duì) XML的支持 ? 配置和其他服務(wù)器應(yīng)用共享內(nèi)存 配置 SQL Server代理 ? SQL Server Agent Must Be Running at All Times ? Configure SQL Server Agent to auto start ? Configure SQL Server and SQL Server Agent services to restart automatically if these services stop unexpectedly ? The SQL Server Agent Logon Account Must Be Mapped to sysadmin Role ? Map this account to the Administrators local group ? Use a Windows domain user account logon account ? Use Windows Authentication Mode for SQL Server Agent 配置 SQLAgentMail 和 SQL Mail SQL Server SQL Mail (SQL Server Service) Executes the xp_sendmail extended stored procedure SQLAgentMail (SQL Server Agent Service) Sends job and alert notifications 配置鏈接服務(wù)器 SQL Server OLE DB Provider File system OLE DB Provider SQL Server 設(shè)置數(shù)據(jù)源名字 ? A Data Source Name Defines ? ODBC driver to use ? Connection information (including name and location of data source, login account, and password) ? Driverspecific options for the connection 配置 SQL Server在 IIS中對(duì) XML的支持 ISAPI Filter Inter Information Services Uses ISAPI Filter () and the OLEDB Provider HTTP Request SQL Server IIS OLE DB XML 配置和其他服務(wù)器應(yīng)用共享內(nèi)存 ? Configuring the Memory Options ? min server memory ? max server memory ? Determining Maximum Amount of Memory ? Using Windows 2022 System Monitor to Observe Effects 例題 ? 54. You want to configure SQL Server to notify you by when an alert occurs. Which series of steps must you perform? A. Configure the SQL Server Agent service to log on as the local system account. Log on to the server running
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1