Data Backup and Recovery

Backup MSSQL with snapcenter (migrate to Netapp Storage)

Ravager
3,794 Views

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

1 ACCEPTED SOLUTION

Ravager
3,705 Views

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

5 REPLIES 5

Ontapforrum
3,774 Views

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
3,747 Views

It was a ad domain account.

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

 

Will attach logs on monday

Ravager
3,706 Views

Weirdly enough reregistering vsc fixed this issue.

 

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

 

Cheers

huebnerdan
2,684 Views

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
2,365 Views
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

Public