hi,

I have a sql server 2000 database which has only one file
and one file group (primary). This file has grow to be
over 40 gig, I want to have two db files for this db,
which should have 20 gig each. What's the best way to do
it?

I don't think 'DBCC SHRINKFILE' with 'emptyfile' command
will do the trick if you only have one .mdf file.

the only way I can think of right now, is to create a new
identical db with two db files defined, and then DTS the
tables from the old db into the new db.

any better and faster ways?

many thanks,

JJ

You want to add a new file/group to your database. Drop and recreate clustered
indexes for the table(s) on the new filegroup. This will move the data for you.


"JJ Wang" <anonymous (AT) discussions (DOT) microsoft.com> wrote

thanks oj. this is a good trick.

JJ