Posted by: scdpm2010 | January 19, 2011

BIG DPM db?

do you have  a Huge DPMDB and the tbl_RM_Recoverysource. table is taking up all the space?

try the solution below taken from the DPM forum

UPDATE tbl_RM_RecoverySource
SET BackupMetadataXml=NULL
WHERE
IsValid=0
GO

DBCC SHRINKDATABASE (‘DPMDB’)
GO


Advertisements

Categories

%d bloggers like this: