Changing the SQL backup location in Time Matters 9.0 Enterprise edition:
Issue: A firm requires that their default TM backup path is changed to a different local or network drive.

Resolution: Edit the SQL script to reference the new drive path.

This article assumes that you are using TMN 9.0 Enterprise and SQL 2005 with SQL Management Studio Express. This page is meant to be used for informational purposes only.

Use the following steps to perform this operation:

1. You may be required to log into the SQL server if the credentials have not been previously saved:

2. Once you are logged into the SQL server with SA (system admin) credentials, look to the left side of the screen and click on the + next to databases to expand the list:

3. Click on the + sign next to your TimeMatters database name and then click on the + next to Programmability:

4. Expand Stored procedures and find tm9user.TM_Backup in the list:

5. Right click on the tm9user.TM_Backup and choose Modify form the menu. The SQL script will appear on the right side of the screen:

6. In order to have TM backup the database to another location you will have to modify the last section of the script. Assuming that your original configuration is: SET @vcBackupDevice = @vcDbName+@vcBaseName+@vcDOW+'.bak' BACKUP DATABASE @vcDbName TO DISK = @vcBackupDevice WITH INIT If your new backup location is G:\Server\Backups here is what the script would look like after the change. Our edits are in bold black text: SET @vcBackupDevice =‘G:\Server\Backups\’+ @vcDbName+@vcBaseName+@vcDOW+'.bak' BACKUP DATABASE @vcDbName TO DISK = @vcBackupDevice WITH INIT

The script MUST be exactly the same as what is listed above or it will fail most likely through an error within Time Matters.