Split existing large DB across multiple physical files

[SQLWilts]

I have a 60GB database (60GB mdf, 5GB ldf). I feel that this should really be split across multiple physical files for scalability, backup, performance etc etc.

I know I can add a physical file easily, but how do I spread the existing data across these files? Is it worth putting each physical file into its own file group, and if so, how do I do this?

Enterprise manager or TSQL is fine - don't really care which.

SQL 2000 Enterprise Edn running on windows 2003 standard with 4GB ram and quad processor.

Any help would be appreciated.

Merry Xmas one and all

 

[ptheriault]

Once you have determined your logical grouping of your tables. You can move them by dropping the PK and recreating the PK on the new filegroup. By moving the Clustered Index it will move the table.

- Paul
- Database performance looks fine, it must be the Network!