Which is better for making a copy of a database, restore or DTS?

[jon.brookins]

Hello everyone!

I'd like to know which method is better for making a copy of an
existing database in SQL Server 2000, restoring from a backup of the
original, or using DTS to copy the objects to the new database. Any
caveats or drawbacks to either method? I'm just trying to lay the
groundwork for internal policies for managing our databases, and I just
want to make sure we use the best method.

Thanks!

[David Portas]

If you need to copy an entire database then I think you'll find Backup /
Restore faster and easier to setup and maintain. If you just need to copy a
subset of data then use DTS.

--
David Portas
SQL Server MVP
--

[m.ramana]

Another thing you might want to consider is If you have identity
columns (linking foreign keys etc) , then it is better to use Restore