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: 2026-03-15

      On 2026-03-15, the Universal Backup Database was slightly changed to standardize the name of the Logs table. Recent databases can be upgraded to the latest version by running the following script: EXEC sp_rename 'dbo.__B_LOGS', '__B_Logs';

    • Universal Backup Database Enhancements: 2026-07-14

      On 2026-07-14, the Universal Backup Database was slightly changed add a few additional columns to certain tables: Recent databases can be upgraded to the latest version by running the following script: IF NOT EXISTS ( SELECT 1 FROM ...

    • Universal Backup Database Enhancements: 2026-05-28

      On 2026-05-28, the Universal Backup Database was slightly changed add a few additional columns to certain tables: Recent databases can be upgraded to the latest version by running the following script: IF NOT EXISTS ( SELECT 1 FROM ...

    • Backup (Pull) Connectors: Development and Enhancement Requests

      A backup/pull connector allows Universal Migrator to connect to source systems and backup/extract the data out. Backup Connector Requirements Whether you are requesting a brand new backup connector or enhancements to an existing one, the following ...

    • Connecting Universal Migrator to an InterSystems Cache Database

      When connecting Universal Migrator to a Cache' database/namespace, you will need to enter the following information into the "Original Data" screen: Choose "in InterSystems Cache'" as the source. For the server name, put the IP address of the Cache ...