sql server dts: DTS Copy Database to new database on same server -- sql server dts

DTS Copy Database to new database on same server

Edwin
9/29/2004 10:36:32 AM

sql server dts: I'm using DTS to copy a database into a new database thats
on the same server in MS SQL Server 2000.. The database is
about 1.5 gigs... i'm wondering how long should this
take? It's been about 20 minutes now and it's stuck at
22%, its been at 22% for the last 20 minutes.. is this
normal? It doesnt seem like it's "frozen" up or anything.

Re: DTS Copy Database to new database on same server

Allan Mitchell
9/29/2004 8:13:30 PM

The 22% thing is a common % for it to look as though it has stopped (when i
used this task).

personally, BACKUP/RESTORE will be far quicker.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

[quoted text, click to view]