Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! See The Solution
1 ACCEPTED SOLUTION
Ravager has accepted the solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Weirdly enough reregistering vsc fixed this issue.
To all intents and purposes vsc was working correctly, so go figure.
Cheers
5 REPLIES 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It was a ad domain account.
Has admin rights on the windows server and sysadmin rights on SQL.
Will attach logs on monday
Ravager has accepted the solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Weirdly enough reregistering vsc fixed this issue.
To all intents and purposes vsc was working correctly, so go figure.
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
