Hi

I get the Filegroup Full when doing a Import from a
flat file using DTS.

The auto growth is on (we have tried % and 1000) and there
is plenty of hard drive space (100Gb) - This file is
around 10Gb, and we have initially given it 4Gb as we
are not sure what we want to put into it.

Why wont it grow ??
We are running SQL 2000

Cheers Paul

It is possible that the growing is not fast enough for your process. If you
know it is going to grow then size it accordingly before the load.

Also

These steps will help keep things low

1. Set the DB recovery mode to simple
2. Remove indices
3. Load in batches (see last tab data pump task)



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Paul Blackler" <pblackler (AT) themis (DOT) co.uk> wrote