Enterprise Manager 

Use

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

Prerequisites

Before you can access a database server with the Enterprise Manager for the first time, you must register the server. To register the server, you need a login ID and a password. Normally the database administrator uses the login ID sa. This enables full access to each database on the registered server.

Features

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 R/3 environment, you can perform the following tasks with the Entreprise Manager:

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 R/3 environment and supplements explanations with recommendations based on the experience gained from R/3 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:

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.

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.

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