Backup MSSQL with snapcenter (migrate to Netapp Storage)

[Ravager]

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

[Ontapforrum]

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!

[Ravager]

It was a ad domain account.

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

Will attach logs on monday

[Ravager · Accepted solution]

Weirdly enough reregistering vsc fixed this issue.

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

Cheers

[huebnerdan]

Hi,

same problem with an MS SQL- database "Not available for backup. DB is not on NetApp storage, auto-close is enabled or in recovery mode."

You wrote "reregistering vsc fixed this issue" - vsc in my opinion stands for "virtual storage console".

Do you mean virtual storage console or snapcenter ?

Do you mean reregistering the host in snapcenter or reregistering (reinstalling) snapcenter himself?

regards

[bobby1977]

Spoiler

Hi,

I am facing the same issue.

I have two SQL server running on Vsphere 7. One SQL is working perfectly after adding SCV in Snapcenter. Second SQL server is showing not available for backup