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