sql管理ppt課件(存儲(chǔ)版)
【正文】 gure the SQL ServerAgent service to use the resulting profile. B. Configure the SQLServerAgent service to log on as a domain user account. Log on to the server running SQL Server as the SQL Server Agent account, and configure connectivity. Configure the SQLServerAgent service to use the resulting profile. ? C. Configure the MSSQLServer service to log on as a domain user account. Log on to the server running SQL Server as the SQL Server account, and configure connectivity. Configure SQL Mail to use the resulting profile. ? D. Configure the MSSQLServer service to log on as a domain user account. Log on to the server running SQL Server as your user account. and configure connectivity. Configure SQL Mail to use the resulting profile. Lab A: 配置 SQL Server 例行 SQL Server管理任務(wù) ? Performing Regularly Scheduled Tasks ? Back up databases ? Import and export data ? Recognizing and Responding to Potential Problems ? Monitor database and log space ? Monitor performance ?自動(dòng)化例行管理任務(wù) ? SQL Server管理的自動(dòng)化 ? 創(chuàng)建作業(yè) ? 驗(yàn)證權(quán)限 ? 定義作業(yè)步驟 ? 決定每一作業(yè)步驟的邏輯性 ? 計(jì)劃作業(yè) ? 創(chuàng)建要通知的操作員 ? 復(fù)習(xí)和配置作業(yè)歷史 Multimedia Presentation: SQL Server管理的自動(dòng)化 創(chuàng)建作業(yè) ? Ensure That the Job Is Enabled ? Specify the Job Owner ? Determine Where the Job Will Execute ? Create a Job Category 驗(yàn)證權(quán)限 ? Executing TransactSQL Jobs ? Execute in the context of the job owner or a specific user ? Executing Operating System Commands or ActiveX Script Jobs ? Members of the sysadmin role use the SQL Server Agent login account ? Job owners that are not members of the sysadmin role use a defined domain user account called a proxy account 定義作業(yè)步驟 ? Using TransactSQL Statements ? Using Operating System Commands ? Using ActiveX Scripts ? Using Replication 決定每一作業(yè)步驟的邏輯性 Job 3 ... Job 2 Back Up Northwind Database Transac
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1