Data Backup and Recovery
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?
See The Solution
Weirdly enough reregistering vsc fixed this issue.
To all intents and purposes vsc was working correctly, so go figure.
View solution in original post
SnapCenter version?During installation of SC Plug-in for SQL 'which account was used' ?Please attach the SC logs.
It was a ad domain account.
Has admin rights on the windows server and sysadmin rights on SQL.
Will attach logs on monday
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?
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
Join our Discord Community