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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-13 : 08:21:40
|
| Nishan writes "Hi,I have a whole lot of working DTS and Linked Servers created using SQL Server 2000 Enterprise Manager. I would like to know the following:1. How do I back up the above to a script?2. How do I restore them to a seperate database?I've got the entire database backed up, but can't seem back up the above. Even the import/export, replication does not seem to backup the following.many thanks nishan" |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2006-02-13 : 23:18:55
|
| You can save the DTS Package from DTS Designer. It will allow you to save as .dts or a vbscript file. If you save it as .dts, then open the package from another server and save it there.ThanksKarunakaran |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-13 : 23:30:09
|
| for the linked server you can sp_addlinkedserver to create the linked server----------------------------------'KH'everything that has a beginning has an end |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-13 : 23:38:04
|
| For those Linked Servers you have created, you can extract the linked servers created from master..sysservers----------------------------------'KH'everything that has a beginning has an end |
|
|
|
|
|
|
DTS/Linked Servers