topic Re: SMSQL Federated Backup and Protection Manager in ONTAP Discussions

SMSQL Federated Backup and Protection Manager

brauntvr2swiss — Thu, 05 Jun 2025 06:30:52 GMT

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

Re: SMSQL Federated Backup and Protection Manager

crocker — Mon, 02 Apr 2012 16:44:03 GMT

@lynda is this one that your team handles or should the question be asked in the NetApp Support Community?

Re: SMSQL Federated Backup and Protection Manager

crocker — Wed, 04 Apr 2012 20:31:38 GMT

Looks like you were not able to help on this issue here. We have external and internal subject matter experts in the NetApp Support Community answering questions about SnapX products and software. If you have a NOW login, this link enables you to engage them about this.

Re: SMSQL Federated Backup and Protection Manager

abhisek — Fri, 06 Apr 2012 07:58:09 GMT

What is the issue you are seeing ?

Re: SMSQL Federated Backup and Protection Manager

brauntvr2swiss — Wed, 11 Apr 2012 13:28:58 GMT

Hi abhisek

The Issue is:

I have Integrated Two SQL Instances in Protection Manager. It mean I have run the SMSQL Configuartion Wizard twice (for every Instance) and in PM I see now 2 Datasets (one Dataset/Instance).

When the Backup of each Instance is running seperatly (without federated Backup), then SMSQL trigger PM for updating the Volumes/Qtrees, which are in the Dataset (-ArchiveBackup).

With the Federated Backup (Two Instances with one SMSQL Job) PM updating only the Dataset, which is linked with the Instance defined with –svr (eg: 'VirtName1/Instance1'). The other Dataset becomes a LAG error in PM, because no updating occurs.....

I hope You understand my explanation of the issue..

TIA

Thomas

Re: SMSQL Federated Backup and Protection Manager

michaelalbers — Mon, 03 Dec 2012 10:24:36 GMT

Hi Thomas,

I ran in the same problem. Have you any solution?

Michael

Re: SMSQL Federated Backup and Protection Manager

brauntvr2swiss — Mon, 03 Dec 2012 15:17:50 GMT

Hi Michael

I dont have a solution for this. Because it was only a Testing Environment we haven't look deeper.

I think Federated Backup doesn't work with Dataset integration, because only for the main Instance

SMSQL creates a Dataset in PM. But this is only thinking and not knowing :-)..

Sorry I don't have a better answer for you...

regards

Thomas

Re: SMSQL Federated Backup and Protection Manager

michaelalbers — Mon, 03 Dec 2012 15:35:49 GMT

Hi Thomas,

bad news....

I'm just upgraded SMSQL from 5.2 to 6.0 with hope that it will work with the new version. Unfortunately it doesn't work.

Tomorrow I will write a powershell script using 'sdcli dataset' registering snapshots of other SQL server with datasets.

Regards

Michael

Re: SMSQL Federated Backup and Protection Manager

qzhang — Wed, 05 Dec 2012 05:54:16 GMT

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

Re: SMSQL Federated Backup and Protection Manager

brauntvr2swiss — Wed, 05 Dec 2012 07:50:42 GMT

Hi Michael

Can you try the Workaround with the registry? When It works, I can mark this discussion as solved 🙂

regards

Thomas

Re: SMSQL Federated Backup and Protection Manager

michaelalbers — Wed, 05 Dec 2012 10:32:19 GMT

Hi Qing,

on next monday I will be at customer site. Then I want to try your solution and giving feedback.

Regards,

Michael

Re: SMSQL Federated Backup and Protection Manager

michaelalbers — Thu, 06 Dec 2012 13:18:52 GMT

Hi Qing,

my customer implemented the workaround and it works like a charme.

Thanks!

Michael

Re: SMSQL Federated Backup and Protection Manager

brauntvr2swiss — Thu, 06 Dec 2012 13:20:54 GMT

Hi Qing

Thanks for your Solution.

regards

Thomas