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.