2013-11-07 06:03 AM - edited 2015-12-18 01:11 AM
Can anyone shed some light on the subject of SMSQL and databases with more than one filegroup? So far I found existing documentation almost non-existent, with the exception of few hints here & there.
Whilst it is possible to share the same set of LUNs (one for log, one for data) across multiple databases with just the default filegroup, it seems that a database with multiple filegroups requires its own LUNs.
Can someone confirm what is true for a database with multiple filegroups:
I'm trying to test all this with SMSQL 6 & SQL 2012, but the configuration wizard fails each time, even when the most radical approach is used, i.e. exclusive LUNs & volumes for my test database with two filegroups (see the error message).
Any hints, suggestions, comments?
2013-11-07 06:32 AM
I moved databases manually to bypass config wizard problem.
So far it looks as follows: