Data Backup and Recovery Discussions

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

1 ACCEPTED SOLUTION

Ravager

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

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

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

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

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public