Subscribe

SQL Snapmanager and VMDK backups

[ Edited ]

I've been trying to wrap my head around using SQL Snapmanager for databases on a VMDk, I've used it with iSCSI luns before but never with VMDK's.

From what I've read it seems to be fairly straightforward with just a 'sdcli smvi_config set -host VSC Server IP' command required to link SQL snapmanager to VSC.

However, the Snapmanger docs also talk about some registry changes but that only seems to be required if there are snapmirrors involved and for this particular setup there won't be.

So bascially I just need to know if setting up SQL Snapmanager is that easy and do I get the ability to pick and choose databases in the same way that I would if this was being hosted on an iSCSI lun?

Also, I've seen some references to creating some sort of 'dr text' file for restores - is this actually required or is that for something else?

Finally, I take it that the SQL snapmanager needs to have IP connectivity to the server running the VSC plugin for this solution to work?

It would be good if there was a technote on setting up SQL Snapmanager for VMDK's

Many thanks for this.

Gary.

Re: SQL Snapmanager and VMDK backups

Hi Gary,

There is a lengthy thread over here with some useful hints: https://communities.netapp.com/message/41629#41629

This TR now includes setting up SMSQL for VMDKs:

http://media.netapp.com/documents/tr-4003.pdf

Regards,

Radek

Re: SQL Snapmanager and VMDK backups

Hi Gary ,

You are correct that as of now some manual work requires to be done for setting up snapmirror relationships with VMDKs including registry changes.

Please halso ave a look into TR 3941 to help you with the deployment guidance for VMDK.

http://media.netapp.com/documents/tr-3941.pdf

Regards,

Abhishek

Re: SQL Snapmanager and VMDK backups

Thanks but tr3941 doesn't list registry changes required for SQL Snapmanager and VMDK's.

Also could some confirm if IP connectivity is required between SQL server and wherever the VSC is installed?

Thank you.

Re: SQL Snapmanager and VMDK backups

SMSQL needs to talk to both vCenter Server & VSC, so yes, you need IP connectivity.

Re: SQL Snapmanager and VMDK backups

TR-4003 lists some registry tweaks, but they are not directly related to VMDKs - from the top of my head, I don't think you need them.

Re: SQL Snapmanager and VMDK backups

Perfect. Thank you all!

From re-reading tr3941 it looks like SQL SNapmanager can be told to connect to VSC so I guess that does the required reg tweaks.

Thanks again.

Re: SQL Snapmanager and VMDK backups

Yes you would require IP connectivity between SMSQL and VSC host box.The registry changes would be required when you try to establish a Snapmirror relationship.

You can also look into TR 3785 for layout related examples .

Re: SQL Snapmanager and VMDK backups

Thanks for all your help guys. One last issue!

I've got SMSQL installed and I've run the configuration wizard but it fails.

'Failed to Load configuration data. Details: Error Code: 0xc004025A Unable to locate active LUN drives on this system'.

Well.... Yes, they are VMDK's so how do tell SMSQL to point to the VMDK's? Is there something I need to do in Snapdrive? Command line? Nothing actually lists these steps or I've missed it.....

Thanks.

Re: SQL Snapmanager and VMDK backups

Did you provide valid credentials to both vCenter & VSC during SnapDrive installation?