tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P115

Microsoft SQL Server 2008 R2 Unleashed- P115:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 1084 CHAPTER 33 Database Maintenance Managing Maintenance Plans Without the Wizard You can create or modify maintenance plans in SQL Server 2008 without using the Maintenance Plan Wizard. To create a new maintenance plan without the wizard you right-click the Maintenance Plan node in the Object Explorer and select New Maintenance Plan. You are prompted for a maintenance plan name and then taken to the Design tab for the maintenance plan. The Design tab consists of a properties section at the top of the screen and a plan designer surface that is empty for a new maintenance plan. Existing maintenance plans are displayed in the Design tab when you right-click the plan and select Modify. Figure shows the Design tab for a maintenance plan that was created with the Maintenance Plan Wizard to back up the system databases. FIGURE The maintenance plan Design tab. The Design tab represents a significant difference from the way maintenance plans were managed in SQL Server 2000. The plan designer surface on the Design tab has drag-and-drop capabilities that allow you to add maintenance tasks to your plan. The available tasks are located in the Toolbox component. The Toolbox and the related tasks are shown in Figure in the middle portion of the screen. To add a tool from the Toolbox you drag the item from the Toolbox to the plan designer surface. Alternatively you can double-click the task and the task appears on the plan designer surface. Download from Managing Maintenance Plans Without the Wizard 1085 On the plan designer surface you can move each of the tasks around link them to other tasks and edit them by double-clicking them. You can also right-click a task to edit it group it with other tasks autosize it and gain access to other task options. You can rightclick an empty section of the plan designer surface to add annotations or comments that provide additional information about the task or the overall plan. NOTE The dialog boxes .