Backup Failure Fix for Time Matters 14.1

Date: Sep. 8, 2015    Categories: backup , upgrading

When upgrading to Time Matters 14.1 from Time Matters 13.2 or earlier, you may get an error message when you try to run a backup from the Time Matters Main Menu.

It takes all of two minutes to apply, but requires the use of and familiarity with SQL Server Management Studio. You can receive assistance from LexisNexis Technical Support or from our company.

Click here to send us an e-mail... If we perform your Time Matters upgrade for you, we apply the fix.

To apply the fix yourself, be careful. SQL queries are powerful and can damage your database.

First, back up the Time Matters database using the backup feature in SQL Server Management Studio.

Next, run this query:

-- Fix the SQL backup in Time Matters 14.1 USE [TimeMatters] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE Function [lntmuid].[fnGetBackupDirectory](@DBName varchar(128)) RETURNS VARCHAR(2000) AS BEGIN DECLARE @BackupDirectory VARCHAR(2000) exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLServer', N'BackupDirectory', @BackupDirectory output RETURN @BackupDirectory END GO