SnapCenter Host Log Directory With Multiple SQL Instances
2020-01-08 12:01 PM
We are in the midst of pushing out the SnapCenter SQL plug-in. We have at least one standalone server with two SQL instances. Under SMSQL we set up a SnapInfo LUN for each SQL instance. Under the SnapCenter plug-in, it appears that I must set up a single LUN for the whole host, not per instance. Is that accurate? If not, how would I add the second LUN since there's only one "configure host directory" link?
Adding to my confusion is the fact that there is a separate host log directory per SQL instance if the instances are in a Windows Failover Cluster, at least if I'm reading the Best Practices Guide correctly. It appears that you fill out a "FCI" log directory for each instance in this case.
1 REPLY 1
Re: SnapCenter Host Log Directory With Multiple SQL Instances
2020-01-14 08:41 AM
To update this thread: somewhat remarkably, I've been informed that there is no way to match the SnapManager for SQL behavior and have a separate Host Log Directory for each SQL instance if the instances are on a standalone system. I've also been informed that there is a RFE that was added a long time ago asking for this feature, but it is "not prioritized" for the next SnapCenter release. I'm now asking what the best practice is for someone in my situation where we have multiple instances and don't have the functionality.