Administering a database server

Administering a database server
Release 9.3

Note:This topic was updated for 9.3.1.

This topic contains links to administration concepts and instructions that apply to ArcSDE database servers.

ArcSDE database servers are instances of Microsoft SQL Server Express that have been enabled to store geodatabases. An installation file for SQL Server Express is included with ArcGIS ArcEditor and ArcInfo, ArcGIS Engine, and ArcGIS Server Workgroup. Also included is a postinstallation setup wizard that enables the SQL Server Express instance to store geodatabases, adds an administrative user to the database server, and—for ArcGIS Server Workgroup—authorizes the software. Be sure to read the installation guide that comes with ArcGIS Desktop, ArcGIS Engine, or ArcGIS Server Workgroup to install SQL Server Express and run the postinstallation setup, because the guide contains step-by-step instructions. A summary of this can be found in the following topic:

Installing SQL Server Express and enabling it to store ArcSDE geodatabases

Once the database server exists, you use ArcCatalog to connect to it.

An overview of database server connections

Adding an ArcSDE database server

Saving a geodatabase connection

Troubleshooting connections to the database server

Next, create a geodatabase.

Creating a new geodatabase

If you have an existing geodatabase from another database server user, you can attach the geodatabase to the database server.

Detaching and attaching a geodatabase on a database server

Add users to the database server and grant them permissions.

Adding and removing users or groups for ArcSDE database servers

User permissions for geodatabases on ArcSDE database servers

Administering user permissions for ArcSDE database servers

Add data to the geodatabase. This is done the same way you would add data to a personal or file geodatabase. The only difference is you must be logged in to the client computer with a login that has sufficient privileges to create data in a geodatabase.

Some ways to add data are explained in the following links:

Creating new datasets using ArcCatalog

Copying feature datasets, classes, and tables to another geodatabase

An overview of importing datasets

Loading data in ArcCatalog

Loading data in ArcMap

Loading features or records from an export file

Once data has been added to or created in the geodatabase, you need to grant users permission to the data and maintain the geodatabase.

Granting and revoking privileges on datasets

Back up and restore geodatabases on an ArcSDE database server

Compressing a geodatabase on an ArcSDE database server

Updating statistics on geodatabases on ArcSDE database servers

Rebuilding indexes on a geodatabase on an ArcSDE database server

Shrinking geodatabases

Upgrading geodatabases on ArcSDE database servers

When administering a database server, you may need to disconnect from or delete it from the Catalog tree. You might also need to stop or suspend the database server so users cannot connect to it.

Disconnecting from an ArcSDE database server

Deleting an ArcSDE database server

Administering a database server

Administering a database server

See Also