In the DTS designer, create a connection for the server to restore to.
Then create an Execute SQL Task using that connection with the SQL
Statement "RESTORE DATABASE mydb...".

-----Original Message-----
From: Aaron [mailto:[Email Address Removed]
Sent: Monday, January 26, 2004 3:43 PM
To: LazyDBA.com Discussion
Subject: Backups.


I'm looking for a way to replication two databases nightly. Is it
possible to use DTS to restore a backup from one server to another? It
makes sense, but I can't seem to figure out how to build the DTS
package.

Thanks
a

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get
today's cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page