Back up and restore a database or Access project (ADP)
You can back up and restore a database in Microsoft SQL Server 2000 Desktop Engine from a Microsoft Access project. You should backup a database frequently and regularly to help protect your data from hardware failure or accidental loss. You can then restore the data from the backup you created at the time it was created. To backup and restore a database in SQL Server, use SQL Server Enterprise Manager. For more information on backing up and restoring databases and SQL Server Enterprise Manager, see the SQL Server documentation.
You can also back up and restore an Access project (.adp), which is a file separate from (but connected to) the SQL Server database.
Back up and restore a SQL Server database
- Open an Access project connected to SQL Server 2000 Desktop Engine.
- Point to Database Utilities on the Tools menu and then click Back Up SQL Database.
The Save Backup As dialog box is displayed and prompts you for a backup file name (.dat).
- Type a name for the backup file in the File name box, or use the default name entered by Access.
Note To restore a database, you must disconnect all users from the database and close all windows except the Database window.
- Open an Access project connected to SQL Server 2000 Desktop Engine.
- Point to Database Utilities on the Tools menu and then click Restore SQL Database.
The Restore dialog box is displayed.
- Type the name of the file in the File name box or locate the backup file (.dat) in the Restore dialog box.
Back up and restore an Access project
- Save and close all objects in the Access project.
- On the File menu, click Back Up Project.
- In the Save Backup As dialog box, specify the name and location of the backup copy.
Restore an Access project from a backup copy
- Depending on what method was used originally to produce the backup copy, use My Computer, the Windows 2000 or later Backup and Recovery Tools, or other backup software to copy the backup Access project to your database folder.
Caution If the existing Access project in the database folder and the backup copy have the same name, restoring the backup copy may replace the existing file. If you want to save the existing file, rename it before you copy the backup Access project.
Note You can back up individual database objects by creating a blank Access project and then importing the objects you want from the original database.