ONTAP Discussions

SMSQL Federated Backup and Protection Manager

brauntvr2swiss
7,006 Views

Hi All

I have a question about SMSQL Federated Backup:

I have a 2 node Windows 2008 Cluster with two SQL Instances on it:

VirtName1/Instance1

VirtName2/Instance2

I have execute the Configuration Wizard on the 2 Instances with PM integration. This Task has created two Datasets in PM and with the "normal" Backup the snapshots are archived (See Jobs above)

SmsqlJobLauncher.exe new-backup  –svr 'VirtName1/Instance1' -ver  –verInst 'VirtName3/Instance3' -mp  –mpdir '' -RetainBackupDays  7 -lb -bksif -RetainSnapofSnapInfo 8 -trlog  –mgmt standard  -ArchiveBackup  -ArchivedBackupRetention Daily

SmsqlJobLauncher.exe new-backup  –svr 'VirtName2/Instance2' -ver  –verInst 'VirtName3/Instance3' -mp  –mpdir '' -RetainBackupDays  7 -lb -bksif -RetainSnapofSnapInfo 8 -trlog  –mgmt standard  -ArchiveBackup  -ArchivedBackupRetention Daily

new-backup  –svr 'VirtName1/Instance1' -g  '2',  'VirtName1/Instance1', '3', 'db1', 'db2', 'db3',   'VirtName2/Instance2', '1', 'db1' -RetainBackupDays  3 -bksif -RetainSnapofSnapInfo 4 -rubackups 1 –mgmt standard -ArchiveBackup  -ArchivedBackupRetention Daily

1 ACCEPTED SOLUTION

qzhang
7,005 Views

You can try the following registry key workaround:

On the machine which you have database which is part of federated backup, under HKEY_LOCAL_MACHINE\SOFTWARE\Network Appliance\SnapManager for SQL Server\Server

Add DWORD_REG key value named “ArchiveRemoteFederatedBackup”, set it value to 1.

Thanks,

-Qing

View solution in original post

12 REPLIES 12
Public