Hi,
IHAC uses following command to backup the MS SQL Server to local files, then uses OSSV to backup the local files.
EXECUTE master.dbo.xp_create_subdir N'E:\DBABackup\OSSQCN_CONFIG'
GO
EXECUTE master.dbo.xp_create_subdir N'E:\DBABackup\OSSQCN_ADMIN'
GO
EXECUTE master.dbo.xp_create_subdir N'E:\DBABackup\OSSQCN_CONTENT1'
GO
EXECUTE master.dbo.xp_create_subdir N'E:\DBABackup\OSSQCN_CONTENT2'
GO
BACKUP DATABASE [OSSQCN_CONFIG] TO DISK = N'E:\DBABackup\OSSQCN_CONFIG\OSSQCN_CONFIG_backup_201108051345.bak' WITH NOFORMAT, NOINIT, NAME = N'OSSQCN_CONFIG_backup_20110805134519', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [OSSQCN_ADMIN] TO DISK = N'E:\DBABackup\OSSQCN_ADMIN\OSSQCN_ADMIN_backup_201108051345.bak' WITH NOFORMAT, NOINIT, NAME = N'OSSQCN_ADMIN_backup_20110805134519', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [OSSQCN_CONTENT1] TO DISK = N'E:\DBABackup\OSSQCN_CONTENT1\OSSQCN_CONTENT1_backup_201108051345.bak' WITH NOFORMAT, NOINIT, NAME = N'OSSQCN_CONTENT1_backup_20110805134519', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [OSSQCN_CONTENT2] TO DISK = N'E:\DBABackup\OSSQCN_CONTENT2\OSSQCN_CONTENT2_backup_201108051345.bak' WITH NOFORMAT, NOINIT, NAME = N'OSSQCN_CONTENT2_backup_20110805134519', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
After several days backup, we find the dedupe ratio is very low.
Does anybody know how to improve the dedupe ratio? Is it because of the database backup parameters?
Thanks,
Jeff