Enterprise Manager (SQL Server 2000)


The Enterprise Manager is a graphical tool included in Microsoft SQL Server 2000 that provides a user-friendly way to administer SQL Servers. It is useful for performing the majority of daily administrative tasks.


Before you can access a database server with the Enterprise Manager for the first time, you must register the server. For more information see Registering a Server.


With the SQL Enterprise Manager you can perform almost all of the tasks required to administer a database. These are comprehensively documented in the SQL Server Books Online.

In an SAP environment, you can perform the following tasks with the Enterprise Manager:

·        Start and stop the SQL Server

·        Configure the SQL Server

·        Configure databases

·        Back up and restore databases

·        Create and manage jobs

·        Create and manage database objects

·        Monitor current server activity

·        View the SQL Server error log

·        View the SQL Server Agent error log

·        Manage local and remote servers

This SAP documentation includes instructions on how to perform certain tasks in the Enterprise Manager, but does not intend to replace the SQL Server Books Online. It focuses on some central tasks that frequently need to be executed in an SAP environment and supplements explanations with recommendations based on the experience gained from the SAP system on SQL Server implementations.

Menu Options

The Enterprise Manager allows you to access options in different ways. The starting point is normally the hierarchy of server components displayed in the left-hand pane of the Enterprise Manager. When the hierarchy is fully expanded, you can select  a component and then choose an action to execute for the component. The actions available for a selected component can be accessed in different ways:

·        From the Action menu

All the options available for a particular component are listed in the main menu under Action. As soon as you change your selection, for example to <SAPSID> database, the list of options offered changes dynamically.

·        From the context menu

When you click on a component in the hierarchy with the right mouse button, all options available for that specific item are listed in a popup menu. The menu appears directly beside the selected component and can therefore be very quickly and easily activated.

·        From the pane on the right-hand side.

This approach allows you to choose actions while you are navigating through information displayed in the right hand pane. For example, if you have selected a database and are viewing information about free space, you can immediately choose to expand the database. The option you need is displayed directly beside the information and you simply need to click on it.

This method of choosing to perform an action is probably the most straightforward. However, only a subset of functions is offered, so you will not always see the option you require.

This documentation explains actions using the main menu. It is however advisable to experiment with different methods to find out which suits you best.

Query Analyzer

Although the Enterprise Manager is primarily a graphic tool that enables you to perform tasks by navigating through a series of menus and dialog boxes, there are many situations where direct access to the database is desirable. The Query Analyzer that can be started from the Enterprise Manager allows you to access the database directly with SQL Statements and stored procedures. You can perform all database operations by entering queries, for example, you can read and modify data or create and drop tables.

See also:

Database Backup

Database Restore

Database Server Checks

Database Server Management