sqlbaby2 (9/1/2015)
Thanks for the replied. Is that mean filegroups only useful if I've multiples data files ? For instance sales data files can group to filegroup sales, marketing data files go to filegroup marketing.
Well, yes. A filegroup is a group of files (1 or more). You have one filegroup when you create a database (PRIMARY). You can create additional filegroups, but without files in them, it would be kinda pointless.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability