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
SnapCenter SQL Plug-In Host Log Directory vs. SMSQL SnapInfo
2018-10-01
08:38 AM
5,500 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
We are gearing up to transition from SMSQL to the SnapCenter SQL Plug-In. If I'm reading correctly, a LUN for the Host Log Directory replaces the SnapInfo LUN from SMSQL. My question for anyone who's done this - can this be the same LUN? In other words, can we point the Host Log Directory to the same LUN we hosted SnapInfo on, and later delete the SnapInfo content off of the LUN? Is there any reason this wouldn't work?
Solved! See The Solution
1 ACCEPTED SOLUTION
TMADOCTHOMAS has accepted the solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SQL instances running on a Windows Failover Cluster/SQL cluster is essentially referring to SQL FCI instance.
"In a Windows cluster environment, you must configure a host log directory for each host" --> This is required only in case the individual nodes/host are having any Standalone SQL Instances.
Else you can select the Cluster and set the host log directory for your FCI Instance.
5 REPLIES 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi TMADOCTHOMAS,
The only requirement is that Host Log Directory should be a LUN from NetApp Storage.
Once you transition to SnapCenter, you may configure your SQL plugin host and assign the host log directory to the same disk/lun. There is no limitation in that. But please do make sure that the disk will be from now on used solely by SnapCenter. Please do cleanup the disk before starting to work on SnapCenter SQL workflows.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks @mrahul! One of the things you said was:
"But please do make sure that the disk will be from now on used solely by SnapCenter. Please do cleanup the disk before starting to work on SnapCenter SQL workflows."
So essentially we would need to point the Host Log Directory to the LUN, delete the SnapManager for SQL content on that LUN, and then start using it with SnapCenter? I was hoping to retain the data for a day in case we needed it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@mrahul (or anyone else), I have a follow-up question. Obviously our deployment got delayed 🙂 but we are picking it back up this summer.
I just re-read the documentation and read something surprising:
-----------------------------------
"You can set up one log directory per host. You cannot set up a log directory per instance."
-----------------------------------
Is this accurate? In our existing SnapManager for SQL setup, we have one log directory per SQL instance.
Also, I'm not clear on what this line means:
-----------------------------------
"In a Windows cluster environment, you must configure a host log directory for each host. For an
SQL cluster, you must set a host log for the Failover Cluster Instance (FCI)."
-----------------------------------
We have SQL instances running on a Windows Failover Cluster. Is this the same thing as a SQL cluster in this terminology, or is a SQL cluster considered something completely different? In other words, do we need this additional host log for the FCI (and if we do, can it be the same LUN as the host log directory)?
TMADOCTHOMAS has accepted the solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SQL instances running on a Windows Failover Cluster/SQL cluster is essentially referring to SQL FCI instance.
"In a Windows cluster environment, you must configure a host log directory for each host" --> This is required only in case the individual nodes/host are having any Standalone SQL Instances.
Else you can select the Cluster and set the host log directory for your FCI Instance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@mrahul thank you very much! That answers my question.
