Microsoft® SQL Server™ includes many wizards that you can use to perform complex administrative tasks. Unless otherwise noted, the wizards can be accessed from the Tools menu in SQL Server Enterprise Manager.
| Wizard | Function |
|---|---|
| Backup Wizard | Guides you through the process of backing up a database. For more information about backing up a database, see Creating and Restoring a Database Backup. |
| Failover Setup Wizard | Guides you through the process of setting up SQL Server Failover Support. This wizard is available only if you install SQL Server Enterprise Edition. For more information about setting up failover support, see Managing SQL Server on a Cluster. |
| Configure Publishing and Distribution Wizard | Guides you through the process of configuring a publishing and a distribution server for replication. Help is included with this wizard. For more information about configuring a publishing and distribution server, see Using the Configure Publishing and Distribution Wizard. |
| Create Alert Wizard | Guides you through the process of creating an alert. For more information about creating an alert, see Defining Alerts. |
| Create Database Wizard | Guides you through the process of creating a database. For more information about creating a database, see Creating a Database. |
| Create Diagram Wizard | Guides you through the process of creating a database diagram. For more information about creating a database diagram, see Creating and Managing Database Diagrams. |
| Create Index Wizard | Guides you through the process of creating an index. For more information about creating an index, see Creating an Index. |
| Create Job Wizard | Guides you through the process of creating a job. For more information about creating a job, see Defining Jobs. |
| Create New Data Source Wizard | Guides you through the installation of an ODBC data source and ODBC driver. Tests the validity of the connection. Help is included with this wizard. For more information about installing an ODBC data source, see Adding a Data Source. To access this wizard, in Control Panel, double-click ODBC Data Sources, and then click Add. |
| Create Login Wizard | Guides you through the process of granting SQL Server login access to users. For more information about creating a SQL Server login, see Using the Create Login Wizard. |
| Create Publication Wizard | Guides you through the process of creating a publication for replication. Help is included with this wizard. For more information about creating a publication, see Using the Create Publication Wizard to Configure a Distributor. |
| Create Stored Procedure Wizard | Guides you through the process of creating stored procedures for adding, deleting, and updating rows in a table. For more information about creating a stored procedure, see Creating a Stored Procedure. |
| Create Trace Wizard | Guides you through the process of creating a trace. For more information about creating a trace, see Creating Traces. |
| Create View Wizard | Guides you through the process of creating a view. For more information about creating a view, see Creating a View. |
| Database Maintenance Plan Wizard | Guides you through the process of creating a maintenance file that can be run on a regular basis. Works with the sqlmaint utility. For more information about creating a maintenance file, see Database Maintenance Plan Wizard. |
| Disable Publishing and Distribution Wizard | Guides you through the process of disabling a publication and a distribution server for replication. Help is included with this wizard. For more information about disabling a publication and distribution server, see Disabling Publishing and Distribution. |
| DTS Export Wizard | Guides you through the process of creating DTS packages to export data from a SQL Server database to heterogeneous data sources. Help is included with this wizard. For more information about exporting data, see Understanding Data Transformation Services. |
| DTS Import Wizard | Guides you through the process of creating DTS packages to import heterogeneous data to a SQL Server database. Help is included with this wizard. For more information about importing data, see Understanding Data Transformation Services. |
| Full-Text Indexing Wizard | Guides you through the process of defining full-text indexing on SQL Server character-based columns. Creates or modifies population schedules that determine when the information stored in the full-text catalog is updated. For more information about full-text indexing, see Full-text Indexes. |
| Index Tuning Wizard | Guides you through the process of tuning an index. For more information about tuning an index, see Index Tuning Wizard. |
| Make Master Server Wizard | Guides you through the process of setting up a master server. For more information about setting up a master server, see Defining Multiserver Jobs. |
| Make Target Server Wizard | Guides you through the process of setting up a target server and enlisting it into a master server. For more information about setting up a target server, see Defining Multiserver Jobs. |
| Pull Subscription Wizard | Guides you through the process of enabling a subscription server to pull replicated data from a publication server. Help is included with this wizard. For more information about enabling a subscription server, see Using the Push and Pull Subscription Wizards. |
| Push Subscription Wizard | Guides you through the process of enabling a publication server to push replicated data to a subscription server. Help is included with this wizard. For more information about enabling a publication server, see Using the Push and Pull Subscription Wizards. |
| Register Server Wizard | Guides you through the process of registering SQL Servers. For more information about registering a server, see Registering Servers. |
| SQL Server Upgrade Wizard | Guides you through the process of upgrading SQL Server. The SQL Server Upgrade Wizard is not supported on the Microsoft Windows® 95/98 platform. For more information about upgrading SQL Server, see Upgrade Options. To access this wizard, on the Start menu, point to Programs, point to Microsoft SQL Server - Switch, and then click SQL Server Upgrade Wizard. |
| Web Assistant Wizard | Guides you through the steps required to create a Web task that creates an HTML page, to import data from an HTML page, or to run an existing Web task. For more information about Web tasks, see Using the Web Assistant Wizard. |