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

4 REPLIES 4

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

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!

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

Ravager

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

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

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

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

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums
Public