Split database to different SQL Server

Sorry for my English.

There is database on SQL Server 2005 Enterprise. I wrote program which splits all tables on fileGroups by datetime. But the problem is that database开发者_如何转开发 schema is not designed for it and most information stays on the PRIMARY filegroup.

Please tell me how I can spread (split) tables onto two or more database servers for increased performance?

Are you looking for the syntax on how to move a table from one file group to another? See ALTER TABLE

ALTER TABLE dbo.MyTable
MOVE TO MyNewFileGroup

It sounds to me like you need to look into MS SQL Server's partitioning capabilities. You should not be doing this manually. Let the database solve that issue for you.