Hi:



I have SQL Server 2000; a database with three file groups located in three
different operating system files; the database size is 200GB; for
performance reasons we added an additional storage to the server and we have
an additional disk volume, what we want to do is to add a new datafile
(datafile4) and then use any command or procedure to equally split database
information (data) among the four datafiles.



How this split can be safely performed ?

Any idea or procedure ?



Thanks and best regards,

Federico

Federico G. Babelis (feder***@gazum.com) writes:
One way is to create a new filegroup, and then explicitly move tables and
indexes to the new filegroup with CREATE INDEX ON ... WITH DROP_EXISTING.

If you want to add the file to an existing filegroup, I don't think
there is a way to explicitly move the data, but if you run DBCC DBREINDEX
on some table, I guess the data will be moved around.

Requirement to use Management Studio for local instances
Stored Procedures in Integration Services
Cannot filter members in Management Studio Browsing a Cube
Sql 2005 can't update maintenance plans?
backup remote database to local hard drive or local database?