Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vule
Starting Member
11 Posts |
 Posted - 2004-05-24 : 13:23:48
|
| Hi folks, I have used the DTS Design Package to copy specific data from Server #1 to Server #2. Both of them are on network. They are working very well. Now, I would like to set up the "BACK Feature" on the DTS Design Package to back up the data from Server #2 first before I copy the data from Server #1. Do you guys have any experience about it? please help me out.Thanks,vl |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-24 : 13:52:06
|
| What do you mean backup the data? Why not just use BACKUP DATABASE? Or SELECT * INTO?Tara |
 |
|
|
vule
Starting Member
11 Posts |
Posted - 2004-05-25 : 09:59:09
|
| Tara, I mean that back up database by using DTS Design Package. I would like to set that Backup Database of server #2 first on DTS Design before I copy the data from Server #1. Please help me out.Thanks,vl |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-25 : 12:14:33
|
| I do not know what you mean by backup database. Are you referring to msdb database which is the database where the DTS packages are stored?Tara |
|
|
|
|
|
|
Create Backup Feature on DTS Design page