Sunday, October 22, 2017
 


 

Risk Intelligence

How much will a Data Breach cost your organization?

Locate Sensitive Data across Networks and Workstations

Read More

Secure File Sharing

ShareSync
A business-grade file sync and share service that meets the needs of both users and administrators. ShareSync file sync and share service enables intuitive collaboration and mobility while helping to keep company data secure and protected.
Read more

Clio

Clio is the leading practice management, time & billing and client collaboration platform for small to mid-sized law firms. Your important client data is securely accessible anywhere - from your PC, your Mac, and even your iPhone.
Read more

Text Size

Changing the SQL backup location in Time Matters 9, 10, 11, and 12 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 TM 9, 10, 11, or 12 Enterprise and SQL 2005, 2008, or 2012 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:
APCG Tip4a
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:
APCG Tip4b
3. Click on the + sign next to your TimeMatters database name and then click on the + next to Programmability:
APCG Tip4c
4. Expand Stored procedures and find tm9user.TM_Backup in the list:
APCG Tip4d
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:
APCG Tips4e
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.