ArcGIS Server Banner

Back up and restore geodatabases on an ArcSDE database server

Back up and restore geodatabases on an ArcSDE database server

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

About backup and restoration of geodatabases

A backup is a copy of the geodatabase that can be restored if a problem occurs. ArcSDE geodatabases for SQL Server Express support simple backup and recovery.

The Administration tab of the geodatabase's Properties dialog box indicates the name of the last backup file and the date when a backup was last performed for the geodatabase.

A geodatabase backup operation can be performed by a geodatabase administrator or a database server administrator. Geodatabase recovery to a database server can only be performed by a database server administrator.

How to back up and restore a geodatabase on a database server

Back up a geodatabase

  1. From the Catalog tree, connect to the database server that contains the geodatabase for which you want to create a backup.
  2. Right-click the geodatabase for which you want to create a backup file, click Administration, and click Backup.
  3. Type a name for your backup file in the Backup name text box.
  4. The backup file will be created in a default location. To change this, type or navigate to the new location to which you want to save the backup file.
  5. NOTE: You will only be able to navigate to a location if you are a database server administrator. If you are a geodatabase administrator, you must type the path to the location.

  6. If you want, type a description for the backup file in the Description text box.
  7. Click OK.

Tip

  • If the geodatabase file is large, it may take several minutes to complete the backup operation. The message box with the taskbar will close when the backup is complete.

Restore a geodatabase

  1. From the Catalog tree, right-click the database server to which you want to restore a geodatabase backup file.
  2. Click Restore on the context menu.
  3. Click the ellipsis (...) button in the Restore geodatabase dialog box to browse to the backup file you want to restore and the location where you want to restore the geodatabase file.
  4. Click OK.
  5. The geodatabase will be restored under its original name. If a geodatabase with that name already exists, you will be asked if you want to overwrite the existing geodatabase. If you do, click Yes. If not, click Cancel.

Tips

  • Only a database server administrator can restore a geodatabase to the database server.
  • If you are restoring over the top of an existing geodatabase, no one can be connected to that geodatabase. If anyone is connected, the restore operation will fail.

See Also

  • About database backup and recovery