In order to backup the database, the SQL server's existing administration tools such as SQL Server 2000 Enterprise Manager, or SQL Server 2005 Management Studio can be used.
PLEASE NOTE: If you are running the Track-It! database on SQL Server 2005 or 2008 Express, or do not have any database administration tools installed, download and install SQL Server Management Studio Express from the following locations, depending on the version. These tools can be used to manage any SQL Server 2005 or 2008 Express, SQL Server 2005, SQL Server 2000, or MSDE database:
SQL Server 2005 Express:
Microsoft SQL Server 2005 Management Studio Express.
SQL Server 2008 Express:
Microsoft SQL Server 2008 R2 Management Studio Express.
For specific information on installing SQL Server 2008 R2 Management Studio Express, please see
artticle TIA06324.
How to Backup the Track-It! Database
Before backing up the Track-It! database be sure to have everyone close out of any Track-It! applications. In addition, stop the following services. Some services will only appear with certain versions of Track-It! 8:
All Track-It! 8 Versions
IIS ADMIN Service
World Wide Web Publishing Service
SmaRTIndexServer
Track-It! 8.0 Account Management Service
Track-It! 8.0 Monitor Service
Track-It! User Synchronization Service
Track-It! Builds 8.0.30.10 and prior
Track-It! Configuration
Track-It! Dashboard Monitor
Track-It! File Storage
Track-It! Monitor
Track-It! Search
Track-It! Software Licensing Monitor
Track-It! System Notification Monitor
Track-It! Work Order Monitor
Track-It! 8.5 (8.0.50.124), All Versions of 9, 10.x, and 11
Track-It! Service Management service
SQL Server 2000- Open SQL Enterprise Manager on the existing Track-It! SQL 2000 Server.
- Expand Microsoft SQL Servers, SQL Server Group and the name of the SQL Server.
- Right click the Track-It! database and select All Tasks -> Backup Database...
- Click the Add button.
- Click the Browse button (...), browse to the location where the database backup will be saved, and give it a file name.
- Click Ok, and Ok again.
- Back at the SQL Server Backup window select Overwrite existing media.
- Click Ok to begin the backup process.
- Click Ok once the backup is complete.
SQL Server 2005/2008/2012, SQL Server 2005/2008 Express- Open SQL Server Management Studio (or SQL Server Management Studio Express) on the existing Track-It! SQL database server.
- Login as SA or an SA equivalent account.
- Expand the Databases folder.
- Right-click the database that you would like to backup and select Tasks -> Back Up.
- If a file path already appears in the "Destination" window at the bottom, take note of the path and name of the backup file that will be created and skip down to step 9.
If a file path does not exist in the window, click the Add button and continue with the steps below.
- Click the ellipse button to the right of the "File name" field.
- In the "File name" field at the bottom of the "Locate Database Files" window, enter the desired backup file name. This will be the name of the backup file once the backup is complete. Take note of the path where the backup file will be created.
- Click Ok Locate Database Files window and then click Ok to close the "Select Backup Destination" window.
- Click Ok to begin the backup.
- Click Ok once the backup is complete.