tailieunhanh - Brad’s Sure Guide to SQL Server Maintenance Plans- P7

Brad’s Sure Guide to SQL Server Maintenance Plans- P7: 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 The Database Mail Configuration Wizard does several different tasks. To set up Database Mail for use by the Maintenance Wizard select the option Set up Database Mail by performing the following tasks. The wizard even lists the three tasks that need to be completed to set up Database Mail which are explained shortly. Click on Next to continue. If database mail has not yet been enabled for this SQL Server instance then you will see the screen shown in Figure . If it has been enabled you won t see the screen. Figure Before you can configure Database Mail you must first enable it. 31 Chapter 2 Before you Create any Maintenance Plans. Assuming that Database Mail has not been turned on for this SQL Server instance and you see the above screen click Yes and Database Mail will be enabled. The next screen shown in Figure will prompt you to create a Database Mail profile. A profile is a collection of one or more SMTP accounts that can be used by SQL Server to send messages. In other words when SQL Server wants to send a message the message is sent to the profile and then the profile is responsible for seeing that the e-mail is actually delivered. For fault tolerance a profile can include more than one SMTP account. For example if the profile tries to send an e-mail using one SMTP account but it is not working then the profile will attempt to send the e-mail using a second SMTP account assuming one is available. Profiles can also be used as a security measure either allowing or preventing someone from using it to send mail. Figure The first step when configuring Database Mail is to create a new profile. To create a new profile you must enter a profile name an optional description and then add and configure one or more SMTP accounts. In this example we will create and configure a single SMTP account. 32 Chapter 2 Before you Create any Maintenance Plans. Multiple mail profiles Database Mail can have .