I have a SQL Server 12.0.5223.6 instance with a database on it.
I'm wondering if I can create a filegroup for one (or more) tables while it's running? Or does it have to have no data in the tables?
I could take the DB offline, but I can't take it offline for long. Right now all the data is inside
Data.mdf. I'm hoping to split out some data from maybe three or four tables into separate filegroups.
Could this be done?