Define the rules for designing Files and File groups in SQL Server.

Define the rules for designing Files and File groups in SQL Server.

A file or file group can only be used by one database. For example, the files abc.mdf and abc.ndf contains data and objects for abc database, cannot be used by any other database.
A file can be a member of only one file group.
Data and transaction log information cannot be part of the same file or file group.
Transaction log files can't be part of a file group.