611
Chapter 22: Maintaining the Database
22
- Choose a connection name that refl ects the server and instance. Using a name
such as My Connection isn’t particularly helpful when you need to troubleshoot the
maintenance task later. You can either type the server and instance name or select
it from a list that the Maintenance Plan provides when you click the ellipses next
to the Select or Enter a Server Name fi eld. - Finally, choose between Windows integrated or SQL Server security.
- Click OK to add the new connection to the list.
FIGURE 22-7
Add new connections as needed to perform maintenance tasks.The Manage Connections dialog box also enables you to edit existing connections or remove
old connections. When you edit an existing connection, you see a New Connection dialog
box in which you can change the logon arguments or the server name for the connection.
The dialog box grays out the other fi elds. Simply click Remove to delete a connection you
no longer need from the list.Connection deletion is a one-way process, and it happens quite quickly. Make sure you have the correct connec-
tion selected before you click Remove because the Maintenance Plan won't ask for confi rmation before deleting the
connection.Logging the Maintenance Progress
Many of the maintenance tasks that you automate execute during off hours, when
you’re unlikely to be around to monitor the system. Fortunately, you can set mainte-
nance tasks to log and report their actions so that you don’t need to watch them every
moment. To use this feature, click the Reporting and Logging icon next to the Manage
Connections icon. You see the Reporting and Logging dialog box, as shown in
Figure 22-8.c22.indd 611c22.indd 611 7/31/2012 9:24:33 AM7/31/2012 9:24:33 AM
http://www.it-ebooks.info