Universal Backup Database Enhancements: 2026-02-16

Universal Backup Database Enhancements: 2026-02-16

On 2026-02-16, the Universal Backup Database was enhanced with expanded logging capabilities.
Recent databases can be upgraded to the latest version by running the following script:

  2. EXEC sp_MSforeachtable
  3.         '
  4.         ALTER TABLE ? ADD
  5.             Log_Updated_At DATETIMEOFFSET(7) NULL,
  6.             Error_Date DATETIMEOFFSET(7) NULL,
  7.             Progress_Started_At DATETIMEOFFSET(7) NULL,
  8.             Result_Started_At DATETIMEOFFSET(7) NULL,
  9.             Source_Started_At DATETIMEOFFSET(7) NULL,
  10.             Log_Duration_Total FLOAT NULL,
  11.             Result_Duration FLOAT NULL,
  12.             Source_Duration FLOAT NULL,
  13.             Progress_Duration FLOAT NULL,
  14.             Log_History NVARCHAR(MAX) NOT NULL DEFAULT(''''),
  15.             Error_ReferenceCode NVARCHAR(MAX) NOT NULL DEFAULT(''''),
  16.             Error_Subject NVARCHAR(MAX) NOT NULL DEFAULT(''''),
  17.             Action_IsRunning BIT NOT NULL DEFAULT(0),
  18.             Error_Agent NVARCHAR(MAX) NOT NULL DEFAULT(''''),
  19.             Error_Description NVARCHAR(MAX) NOT NULL DEFAULT(''''),
  20.             Progress_Agent NVARCHAR(MAX) NOT NULL DEFAULT(''''),
  21.             Progress_Log NVARCHAR(MAX) NOT NULL DEFAULT(''''),
  22.             Result_Warning NVARCHAR(MAX) NOT NULL DEFAULT(''''),
  23.             Source_Warning NVARCHAR(MAX) NOT NULL DEFAULT('''');
  24.             ';



  28. GO
  29. PRINT 'Step 1 Complete - Columns Added';
  30. EXEC sp_MSforeachtable
  31.     '
  32.         UPDATE ?
  33.         SET
  34.             Log_Duration_Total = DATEDIFF(MINUTE, Log_Date_From, Log_Date_Till),
  35.             Result_Duration    = DATEDIFF(MINUTE, Result_Date_From, Result_Date_Till),
  36.             Source_Duration    = DATEDIFF(MINUTE, Source_Date_From, Source_Date_Till),
  37.             Log_Updated_At     = Log_Date_Till,
  38.             Log_History        = Log_Description,
  39.             Error_ReferenceCode= Log_ReferenceCode,
  40.             Error_Subject      = Log_Subject,
  41.             Result_Started_At  = Result_Date_From,
  42.             Source_Started_At  = Source_Date_From,
  43.             Source_Warning     = Comment;
  44.         '
  45. GO
  46. PRINT ''
  47. PRINT 'Step 2 Complete - field values updated';
  48. PRINT ''
  49. PRINT '**************************************************************************'
  50. PRINT 'Upgrade complete';


    • Related Articles

    • Universal Backup Database Enhancements: 2024-09-02

      On 2024-09-02, the Universal Backup Database was Enhanced as Follows: Added Action_Priority column to all tables Recent databases can be upgraded to the latest version by running the following script: EXEC sp_MSforeachtable ' ALTER TABLE ? ADD ...

    • Universal Backup Database Enhancements: 2024-09-18

      On 2024-09-18, the Universal Backup Database was Enhanced as Follows: Renamed *_Role column on __M_Matters_Participating_Entities to *_Participant_Role Recent databases can be upgraded to the latest version by running the following script: exec ...

    • Universal Backup Database Enhancements: 2024-11-21

      On 2024-11-21, the Universal Backup Database was Enhanced as Follows: Added "Subject" columns to Time, Expenses, and Fees Recent databases can be upgraded to the latest version by running the following script: ALTER TABLE ...

    • Universal Backup Database Enhancements: 2025-10-24

      On 2025-10-24, the Universal Backup Database was Enhanced as Follows: Removed the Final_Extra_Content and Original_Extra_Content columns. Information that may have been stored in these columns now resides in the Source_Content columns. Recent ...

    • Universal Migrator Update: 2025-04-01

      If you have a Universal Backup database from a previous version of Universal Migrator, you will need to upgrade it by following the Delta Migration Procedure. New Backup Tools Universal Migrator now includes Backup options for the following ...