Home Forums SQL Server 2005 Administering Database Design: Should we have Multiple Data files and Multiple File Groups – SQL Server 2005 RE: Database Design: Should we have Multiple Data files and Multiple File Groups – SQL Server 2005

  • What edition of SQL Server is this? If it's not Enterprise, you can't restore Primary and then get people working while you restore other files.

    I have heard this advice before, and while it's sound, unless you have a large database and are looking for separating files for performance or better protection of some data, I wouldn't bother.