469,603 Members | 2,057 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

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

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!

Jul 23 '05 #1
2 1159
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
--
Jul 23 '05 #2
Another thing you might want to consider is If you have identity
columns (linking foreign keys etc) , then it is better to use Restore

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Glen A Stromquist | last post: by
2 posts views Thread by Jim Andersen | last post: by
2 posts views Thread by Fabius | last post: by
5 posts views Thread by kebuchan | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.