Importing from SQL7 using DTS wizard

We are trying to import data from a sql 7 machine into sql 2000 using
import wizard in DTS. One of the tables has in excess of 80 million
rows.

The first time we did this it worked fine no problems. However we had
to recreate the database, and it has not worked since.

The error message is reported as ' the log file for 'dbname' is full'.
This happens regardless of the fact that there is 100GB free on disk,
and that the database data and log files are both set to autogrow. The
recovery model is set to simple.

When imported the data.mdf file should be around 20GB.

Would anyone know what is causing this or how to get around this
without going down the SQL7 install, restore and upgrade to sql2000
route?

Any help would be appreciated greatly.Hi

You may want to try attaching the mdf and ldf files from the SQL 7 box onto
the SQL 2000 box and then making any modifications required or restore a
backup.

You don't say how big the log file is. If it is set to grow by a percentage
that value may be larger than the available disk space.

Check out

http://support.microsoft.com/defaul...b;en-us;Q314546
http://support.microsoft.com/defaul...ben-us%3b224071
http://msdn.microsoft.com/library/d...ar_da2_1uzr.asp

John

"John Gill" <pizzaboyo@.yahoo.co.uk> wrote in message
news:a8be1015.0311070405.17c37eb@.posting.google.co m...
> We are trying to import data from a sql 7 machine into sql 2000 using
> import wizard in DTS. One of the tables has in excess of 80 million
> rows.
> The first time we did this it worked fine no problems. However we had
> to recreate the database, and it has not worked since.
> The error message is reported as ' the log file for 'dbname' is full'.
> This happens regardless of the fact that there is 100GB free on disk,
> and that the database data and log files are both set to autogrow. The
> recovery model is set to simple.
> When imported the data.mdf file should be around 20GB.
> Would anyone know what is causing this or how to get around this
> without going down the SQL7 install, restore and upgrade to sql2000
> route?
> Any help would be appreciated greatly.

Importing database to an offline machine.

I have an SQL server 2005 database on my laptop and i want to copy it to my machine at wotk. The two machine can't be connected other than through internet. I am unable to figure out a way to do this. Anyone has any ideas ?!?! Thanks !!

Hi,

You could do an object transfer with DTS or SSIS to the target machine, but that would imply opening some ports to your work machine which is (in the most cases) hardly possible. The best way to do a data transfer is either to detach your db , copy it over and attach it to the working machine OR backup your database copy it over and restore it again on the target system.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de