User guide

13: Database Backup and Restoration
192 —
revision 143
14. Select the Force restore over existing database checkbox.
15. Click [OK].
SQL Server Desktop Engine Database Backup
Procedures
The information below outlines the steps required to conduct database backups of
the BEST ACCESSCONTROL database using a Dell Precision 340, Windows
2000 Operating System, with an SQL Server Desktop Engine database.
While there is an option in the B.A.S.I.S. Backup utility to back up the database
directly to tape, it will not work because the B.A.S.I.S. Backup utility does not
recognize the tape drive that is in the Dell Precision 340. Instead, you must use
the B.A.S.I.S. Backup utility to back up the database to a file, and then use the
Windows Backup utility to back up the file to the tape. The process that must be
followed to back up a file to tape is:
1. Install the drivers for the tape backup device, exactly as you would on an
SQL Server 2000 system. For more information, refer to Install the Drivers
for the Tape Backup Device on page 170.
2. Create a database backup folder in Windows Explorer. For more
information, refer to Create a Database Backup Folder on page 175.
3. Run the B.A.S.I.S. Backup utility to manually back up the database to a file.
For more information, refer to Manually Back Up an SQL Server Desktop
Engine Database to a File on page 193.
4. Using the Windows Backup utility, manually back up the file to a tape. For
more information, refer to Manually Back Up the Database to Tape on page
181.
5. Configure Windows Backup to automatically backup the file to a tape drive.
For more information, refer to Configure Automatic Database File Backup
to Tape Drive on page 183.