Data Backup and Recovery Discussions

Highlighted

Backup MSSQL with snapcenter (migrate to Netapp Storage)

Trying out the MSSQL plugin for the first time but I have an issue.

 

Discovery works fine and all the databases come back ok but there is an error.

Not available for backup. DB is not on NetApp storage, auto-close is enabled or in recovery mode.

 

Its not autoclose or recovery so its obviously a storage issue.

 

Its a Vmware environment using NFS with all Vm's pretty much shared across a number of datastores.

 

What exactly has to be done to make Snapcenter happy, does the SQL logs and data have to be in a seperate NFS datastore or something along these line?

 

Cheers

3 REPLIES 3
Highlighted

Re: Backup MSSQL with snapcenter (migrate to Netapp Storage)

Hi,

 

SnapCenter version?
During installation of SC Plug-in for SQL 'which account was used' ?
Please attach the SC logs.

 

Some references:
https://kb.netapp.com/app/answers/answer_view/a_id/1080187/loc/en_US
https://kb.netapp.com/app/answers/answer_view/a_id/1083839/loc/en_US#__highlight

 

Thanks!

Re: Backup MSSQL with snapcenter (migrate to Netapp Storage)

It was a ad domain account.

Has admin rights on the windows server and sysadmin rights on SQL.

 

Will attach logs on monday

Highlighted

Re: Backup MSSQL with snapcenter (migrate to Netapp Storage)

Weirdly enough reregistering vsc fixed this issue.

 

To all intents and purposes vsc was working correctly, so go figure.

 

Cheers

View solution in original post

Cloud Volumes ONTAP
Review Banner
All Community Forums
Public