Backup and restore

#1

Hi, I've got about 10 SQL servers with a lot of DTS packages.

How can I backup and restore them ?

I' m looking for some information but I don't really find a solution

thank you

#2

Try DTSBackup:

http://www.sqldts.com/default.aspx?242

--
Jacco Schalkwijk
SQL Server MVP

"opianeta" <opianetaNONMISPAMMAREPLEASE (AT) yahoo (DOT) it> wrote

Quote:

Hi, I've got about 10 SQL servers with a lot of DTS packages.

How can I backup and restore them ?

I' m looking for some information but I don't really find a solution

thank you

#3

An MS-SQL instance's local 'msdb' stores all DTS pkg
info. Just dump this DB like any other user or system
database & you have a complete backup of all
packages. ;-)

-DMllp/DBA

Quote:

-----Original Message-----
Hi, I've got about 10 SQL servers with a lot of DTS
packages.

How can I backup and restore them ?

I' m looking for some information but I don't really find
a solution

thank you

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Backup and restore

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Backup and restore - 08-17-2004 , 07:26 AM

Re: Backup and restore - 08-17-2004 , 09:00 AM

Backup and restore - 08-18-2004 , 01:32 PM