Backup Failure Fix for Time Matters 14.1

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