topic Help with integrating SMSQL with Protection Manager in Active IQ Unified Manager Discussions

Help with integrating SMSQL with Protection Manager

michaeldparker — Thu, 05 Jun 2025 06:51:19 GMT

Hi All,

We have been using SMSQL with a Windows SQL cluster (Active/Passive, Single SQL instance) for a few weeks with no issues, but now I'd like to integrate it with PM so that we can perform snapvaults to our DR arrays. When going through the backup configuration wizard, the option "Archive backup to Secondary Storage" is greyed out (see the below screen shot) and I an unable to figure out how to resolve this. All of my luns are in 1 lun per qtree, snapdrive has been configured to point to our protection manager server using the "sdcli dfm_config set" command, I have restarted the snapdrive service, searched the web over, etc and I still cannot make it work. We have non-SQL clusters working fine with PM so I know this does work on other servers .... just not this cluster. Any help with this would be greatly appreciated. The servers are Windows 2008 x64 SP2, with SQL 2005 SP3, SMSQL 5.1.0.676, and SnapDrive 6.3.0.4601.

Thanks

Mike

Re: Help with integrating SMSQL with Protection Manager

kryan — Tue, 05 Jul 2011 20:37:17 GMT

Mike,

have you read over this KB?

How to configure SnapManager and SnapDrive Integration with Data Fabric Manager

https://kb.netapp.com/support/index?page=content&id=1011361

Thanks,

Kevin

Help with integrating SMSQL with Protection Manager

michaeldparker — Tue, 05 Jul 2011 20:46:45 GMT

Thanks for the reply. I had not seen this particular document, but I just finished reading through it. Based on the doc, I don't see anything wrong. Any further thoughts?

Thanks

Mike

Re: Help with integrating SMSQL with Protection Manager

kryan — Wed, 06 Jul 2011 12:32:13 GMT

Mike,

1) On the SMSQL server, run "sdcli dfm_config list" and ensure the DFM server information is correct.

2) Compare the UserName output from #1 with the same user in "dfm user list" run on the DFM server. Ensure the case matches in the entire string including the Windows domain.

3) Once you have completed #1 and #2, run the SMSQL Config Wizard and configure the dataset. If you have already done this then it will ask to reuse the datset it detected - choose Yes.

4) Using the NMC, edit the dataset and assign a secondary location. Then allow conformance to start the SV relationships.

5) Once the datset is conformant (not protected) the Archive button should be selectable in the Backup Wizard. After the first SMSQL backup the datset will be both conformant and protected.

If you have any problems with the above, open a support case so that we can collect data and troubleshoot via remote session if necessary.

Re: Help with integrating SMSQL with Protection Manager

michaeldparker — Wed, 06 Jul 2011 13:05:29 GMT

This process is still new to me as we've only had NetApp since January and we had a consultant set up a lot of it. In any case, Step 3 is the step I had missed. Once I went through the configuration wizard and assigned a resource pool to the newly create dataset, PM started creating all the proper vault relationships for me and all looks great. I love how easy this is once you know what you're doing.

One question I still have though is I tried to assign a provision policy after the fact. The provision policy was configured to be a secondary with dedupe enabled for manual so that I could enable compression. When I attempted to apply that, I received errors like below on the conformance checking screen. Any idea why? And is there a way to configure the Provision policy to automatically enable compression as well?

The requested size 954 GB is more than the default maximum size (512 GB) allowed for deduplication

Thanks very much.

Re: Help with integrating SMSQL with Protection Manager

adaikkap — Wed, 06 Jul 2011 13:44:15 GMT

Hi,

You are hitting the following bug.

http://now.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=508580

The public report has workaround on how to fix this.

Regards

adai

Re: Help with integrating SMSQL with Protection Manager

michaeldparker — Wed, 06 Jul 2011 13:48:03 GMT

Thanks very much. Least I know it is a bug and not something else stupid on my part.

Re: Help with integrating SMSQL with Protection Manager

adaikkap — Wed, 06 Jul 2011 15:33:41 GMT

Using the workaround specified in the public report you can fix this problem yourself.

Regards

adai

Re: Help with integrating SMSQL with Protection Manager

iworxsupport — Thu, 07 Jul 2011 20:42:37 GMT

Kyran, Thanks so much. I have been fighting with the problem from 2 days trying to figure out why it skips the data protection screen. Saw your post and checked the DFM event log and yup the account i was using was being denied access. THANKS A MILLION.