topic Re: Backup MSSQL with snapcenter (migrate to Netapp Storage) in Data Protection

Backup MSSQL with snapcenter (migrate to Netapp Storage)

Ravager — Wed, 04 Jun 2025 11:19:42 GMT

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

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

Ontapforrum — Sat, 08 Feb 2020 09:01:17 GMT

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)

Ravager — Sat, 08 Feb 2020 20:15:43 GMT

It was a ad domain account.

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

Will attach logs on monday

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

Ravager — Tue, 11 Feb 2020 01:34:39 GMT

Weirdly enough reregistering vsc fixed this issue.

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

Cheers

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

huebnerdan — Thu, 25 Feb 2021 12:33:25 GMT

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

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

bobby1977 — Wed, 02 Jun 2021 09:29:46 GMT

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