IntelliTrack Package Track - Manual (Page 70)

I NTELLI T RACK DMS: P ACKAGE T RACK V 7.0
User Manual
54
3. To change the server connection: In the 1. Select to enter a server
name field, click the drop-down arrow and select the server
name\instance name (if you are using an instance name) on which the
Package Track data file resides from the list that appears. If it is not
listed type the server name in this field.
4. In the 2. Enter information to log on to the server field, select the
Authentication mode used by the server.
5. Select the radio button next to the Use a specific user name and pass-
word option if SQL Server Authentication is used. The User name and
Password fields become enabled. Enter a valid user login and pass-
word in the fields provided.
6. Next, select the database by clicking the option button next to the 3.
Select the database on the server: selection and then clicking the
drop-down arrow in the field underneath this option. If it is not listed,
enter it into this field.
7. Click the Test Connection button to verify the database connection. If
the data file is not attached, select the Attach a database file as a data-
base name: option by entering the logical database name (PTSQL) and
then browsing or entering the data file name, including the full path
(example: C:\Program Files\Microsoft SQL
Server\MSSQL\Data\PTSQL.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:
1. If you have the full version of SQL Server, this process is provided for
by SQL Server.
2. If you are using MSDE (minimal version, containing only basic com-
ponents of SQL Server), you will need to run through a separate data
backup procedure.
Data File
Backup and
Restore with
SQL Server
and SQL
Express SQL Server provides the backup functionality needed to protect data and
backup Package Track data files:
Enterprise manager provides full backup and restore functionality. See
Enterprise Manager documentation for details.