Technical Training
SQL Server 2005 TrainingSQL Server 2005 Installation - Maintenance Plan Without Using Wizard
SQL Server 2005 Installation - Maintenance Plan Without Using Wizard
Earlier you learnt about Maintenance Plan Using Wizard, In this tutorial you will learn about Maintenance Plan Without Using Wizard. You will also learn how to change the tasks in the Maintenance Plan Wizard.
Creating a Maintenance Plan without using the Wizard.
1. In Object Explorer, expand a server, and then expand Management.

2. Right-click Maintenance Plans and select New Maintenance Plan.
3. In the New Maintenance Plan dialog box, type a name for the plan.

4. The Toolbox opens, and the 
5. On the Design tab, enter a description for the plan.
6. To build a plan, drag and drop task flow elements from the Toolbox to the plan design surface in order to define the tasks that will be performed.

7. Double-click tasks to open dialog boxes to configure the task options.

8. To define the workflow between tasks, click the task you want to occur first, hold the Ctrl key down, and click the task you want to occur later, right-click either task, and then click Add Precedence Constraint.

9. Click Connections to add connections to different servers.

10. Click Logging to specify reporting options. You can also select Log extended information to save more detailed information, such as the list of databases that were backed up.

To change the tasks in the Maintenance Plan Wizard
1. On the Tools menu, click Choose Toolbox Items.

2. Select the tools you want to appear in the Maintenance Plan Wizard, and then click OK.

In this section we have learnt the fundamentals of maintaining the SQL Server. A little later in this tutorial we shall see how each of these tasks are configured in greater detail.
SQL Server 2005 Training
- SQL Server 2005 - Configuring Replication
- SQL Server 2005 Replication Enhancements
- SQL Server 2005 - Mirror Server
- SQL Server 2005 - Introduction to Data Availability
- SQL Server 2005 - Backing up a Database
- SQL Server 2005 - Using Database Snapshots
- SQL Server 2005 - Disaster Recovery
- SQL Server 2005 - Managing Certificates
- SQL Server 2005 - Managing Permissions
- Managing SQL Server 2005 Security
- SQL Server 2005 - Using the Database Tuning Advisor
- SQL Server 2005 - Tuning a Database
- Maintain indexes in a SQL Server 2005 database
- SQL Server 2005 - Defining Indexes
- SQL Server 2005 - Database Backup
- SQL Server 2005 - Populating the Database
- SQL Server 2005 Configuration Manager
- SQL Server 2005 - Using the Sqlcmd Utility
- Using the SQL Management Objects
- Using SQL Sever Management Studio - Part 2
- Using SQL Sever Management Studio - Part 1
- SQL Server 2005 - Using Event Notifications
- SQL Server 2005 - Using DDL Triggers
- SQL Server Monitoring Tools - Server Profiler
- SQL Server 2005 - Testing Troubleshooting
- SQL Server 2005 - Upgrading from earlier versions of SQL Server
- SQL Server 2005 Installation - Maintenance Plan Without Using Wizard
- SQL Server 2005 - Unattended Installations
- SQL Server 2005 Installation - Maintenance Plan Using Wizard
- Installing a Second Copy of SQL Server 2005
- Planning to Install SQL Server 2005
- SQL Server 2005 Installation
- SQL server 2005 Editions
- SQL Server 2005 Architecture Overview
- SQL Server 2005 - Management studio interface Summary Page
- SQL Server 2005 - Server Groups
- SQL Server 2005 - Registered Servers
- SQL Server 2005 Administrative Tools
- Developing Client applications in SQL Server 2005
- SQL Server Management Objects
- NET CLR in SQL Server 2005
- Native HTTP Support in SQL Server 2005
- XML Data Types in SQL Server 2005
- Using XML in SQL Server 2005
- Using Notification Services in SQL Server 2005
- SQL Server 2005 - Service Broker
- Data Manipulation Language (DML) in SQL Server 2005
- T-SQL Enhancements in SQL Server 2005
- Security Features in SQL Server 2005 for the Developer
- SQL Server Architecture and Components
- SQL Server 2005 Management Studio
- Overview of SQL Server 2005 for the Database Developer
- Getting started with SQL Server 2005







