TAILIEUCHUNG - Brad’s Sure Guide to SQL Server Maintenance Plans- P8

Brad’s Sure Guide to SQL Server Maintenance Plans- P8: SQL Server has a reputation as being a simple database application to install, configure, and maintain. This is a little misleading. SQL Server is a powerful relational database that can handle the needs of the largest organizations and, as such, its proper maintenance almost certainly requires the attention of an experienced DBA. | Chapter 2 Before you Create any Maintenance Plans. Figure If the SMTP settings are not set correctly Database Mail will not work. Once you re happy with the account information clicking OK will return you to the original mail Profile screen which will display the SMTP account you just set up as shown in Figure . 36 Chapter 2 Before you Create any Maintenance Plans. Figure Although you are only setting up one account you can see that multiple accounts can be set up if desired. To continue with the Database Mail Configuration Wizard click on Next to reach the Manage Profile Security screen shown in Figure . 37 Chapter 2 Before you Create any Maintenance Plans. Figure You have to specify whether a mail profile is public or private. As shown in Figure your Maintenance Plan profile has been created it s called Maintenance Plan . Now you have to assign the profile as either public or private. A private profile is only usable by specific users or roles while a public profile allows any user or role with access to msdb to send mail. To keep your setup as simple as possible make the Maintenance Plan profile public by selecting the checkbox under Public then clicking Next to move on to the Configure System Parameters screen shown in Figure . .

• Cơ sở dữ liệu
• Phân tích thống kê với máy tính
• bảo mật cơ sở dữ liệu
• cơ sở dữ liệu Mysql
• xử lý tín hiệu
• mô phỏng dữ liệu
• SQL căn bản
• ứng dụng máy tính
• phân tích thống kê
• kiểm định giả thiết thống kê
• quy hoạch tuyến tính
• đồ thị Box
• tính toán thống kê
• phương pháp số văn bản