IntelliTrack Check In/Out - Manual (Page 37)

Chapter 1
Introduction
9
base name: option by entering the logical database name (for example,
DATACHE7), and then browsing or entering the data file name, includ-
ing the full path (for example: C:\Program Files\Microsoft
SQL Server\MSSQL\Data\DATACHE7.MDF).
8. Click OK to close the form and attach the database to the application.
Back-End
(Data File)
Maintenance We recommend backing up the back-end data file daily. The backup pro-
cess varies, depending on your version of SQL Server:
• If you have the full version of SQL Server, this process is provided for
by SQL Server.
• If you are using SQL Express (minimal version of SQL Server 2005,
containing only basic components of SQL Server), this process is pro-
vided for by SQL Express.
• If you are using MSDE (minimal version of SQL Server 2000, contain-
ing only basic components of SQL Server 2000), you will need to run
through a separate data backup procedure.
Data File
Backup and
Restore with
SQL Server
and SQL
Express SQL Server and SQL Express provides the backup functionality needed to
protect data and backup Check In-Out data files: Enterprise Manager pro-
vides full backup and restore functionality. See the Enterprise Manager
documentation for details.
IntelliTrack
Backup and
Restore
Utilities IntelliTrack batch utilities may also be used to backup and restore the data-
base. The backup and restore methods are explained in the following sec-
tion:
“Batch Utilities” on page 9 .
Batch Utilities
Backup and Restore batch utilities may be used to perform a daily database
backup and a restore on the last backup.
Note: When you are using MSDE (without the full version of SQL Server)
without a full version of Microsoft Access this is the only backup and
restore option available.
1. Use the Backup and Restore batch utilities to perform a daily database
backup and a restore on the last backup.
2283.book Page 9 Thursday, July 9, 2009 11:26 AM