fredag 14 december 2018

Backup is failing after upgrade MABS v2 -> MABS v3

Recently a client upgraded their MABS (Microsoft Azure Backup Server) V2 to V3 with the result of DAG backups started to failing.

Within the release notes for the MABS V3 its stated that this could happen. To fix this issue you run the following SQL query from the SQL Server Management Studio:

IF EXISTS (SELECT * FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[tbl_PRM_DatasourceLastActiveServerMap]')
    AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
    DROP TABLE [dbo].[tbl_PRM_DatasourceLastActiveServerMap]
    GO

    CREATE TABLE [dbo].[tbl_PRM_DatasourceLastActiveServerMap] (
        [DatasourceId]          [GUID]          NOT NULL,
        [ActiveNode]            [nvarchar](256) NULL,
        [IsGCed]                [bit]           NOT NULL
        ) ON [PRIMARY]
    GO

    ALTER TABLE [dbo].[tbl_PRM_DatasourceLastActiveServerMap] ADD
CONSTRAINT [pk__tbl_PRM_DatasourceLastActiveServerMap__DatasourceId] PRIMARY KEY NONCLUSTERED
    (
        [DatasourceId]
    )  ON [PRIMARY],

CONSTRAINT [DF_tbl_PRM_DatasourceLastActiveServerMap_IsGCed] DEFAULT
    (
        0
    ) FOR [IsGCed]
GO

Inga kommentarer:

Skicka en kommentar