472,806 Members | 1,751 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,806 software developers and data experts.

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.


Jul 23 '05 #1
2 1239
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Glen A Stromquist | last post by:
I have a 6.5 db that I want to create a copy of, I can move it to either a machine running 7 or 2000. I am more used to doing this in Oracle so pls bear with me... I don't want to have any...
by: Jim Andersen | last post by:
I want to take a copy of a database, and mail it to another sql-server, and then get it up and running. I normally detach it, and copy the .MDF. But there are users using the database, so that...
by: Kevin | last post by:
Can anyone recommend the easiest way to get a full copy of a database from one server to another. The servers are not part of the same organization or network. I have received a backup of the...
by: Fabius | last post by:
Hello all. I need transfer a db2 database ( tables, records ecc. ) from a server1 to server2. The operating system of server1 and server2 is win2000 server. I have installed db2 to server2. Now...
by: Knokmans | last post by:
Hi, All of this is still a test envinonment, but has to go on production.... I restore a database a database the follwing way db2 restore db <database> from <directory. taken at <timestamp>...
by: Rachel McConnell | last post by:
Hi, I am trying to import data using COPY, from a file containing thirty or so COPY commands each with 0 or more rows of data. Reason, I have a small data set I want to include into a database...
by: kebuchan | last post by:
Hi all, I know this is possible in Oracle but has anyone done it in DB2 and could you maybe direct me to some documentation or let me know how I would go about doing it? In the oracle world...
by: Mark | last post by:
Hello, if you got a tape file how can you restore the contained database onto a newly installed server? I choose Restore Database From Device then I choose DB and select same DB in combobox "To...
by: Steve | last post by:
Hi; I thought I would rephrase a question I asked in another post to more quickly get to the heart of the matter. My apologies for anyone who is offended by what appears to be a repetition. ...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.