ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Database Server (Desktop) installation guide

New installations

  • Set up a database server
  • Use a command to enable SQL Server Express to store geodatabases
  • Add a database server to ArcMap
  • Add logins to a database server
  • Alter permissions
  • Create a desktop geodatabase

Upgrades

  • Database server upgrades
  • Create a backup of a desktop geodatabase
  • Upgrade SQL Server Express
  • Upgrade a desktop geodatabase

Create a backup of a desktop geodatabase

A backup is a copy of a geodatabase that can be restored if a problem occurs. Geodatabases on database servers use SQL Server simple backup and recovery.

The simple backup and recovery model uses full database backups. It requires the least administration since you do not have to administer transaction log backups and log space. However, in the simple backup and recovery model, data is recoverable only to the most recent backup. Changes made since the last database backup are lost.

How often you perform backups depends on how often the data changes. Your backup schedule should be determined by how much data you feel you can stand to lose. Plan your backups for specific times, such as putting them on the same schedule as your operating system or file backups. If you want to perform backups more frequently, schedule them to occur when others are not accessing the geodatabase, perhaps at the end of the day.

Only a geodatabase administrator or server administrator can create a geodatabase backup.

Tip:

Always make a backup before upgrading a geodatabase or the SQL Server Express instance.

  1. Log in as a server administrator or geodatabase administrator, start ArcMap, and open the Catalog window.
  2. Double-click the database server that contains the geodatabase for which you want to create a backup.

    This connects you to the database server.

  3. Right-click the geodatabase for which you want to create a backup file, click Administration, and click Backup.
  4. Type a name for your backup file in the Backup name text box.
  5. The backup file is created in a default location. To change this, type the path or browse to the new location to which you want to save the backup file.

    You can only browse to a different location if you are a server administrator. If you are a geodatabase administrator, you must type the path to the location.

  6. Type a description for the backup file in the Description text box.
  7. Click OK.
Tip:

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

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal