I got that working quite well, but would it be easier to use attach an
existing database under a new name?

Aaron wrote:

> Right, but I do not think I fully understand the syntax of
> RESTORE ...
>
> RESTORE DATABASE MyNwind
> FROM MyNwind_1 --<< this would be on a different server
>
> It will have to be from a network share as well... and the name will
> change every night ...
>
> [Email Address Removed] wrote:
>
>> 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] ---------------------------------------------------------------------
>> 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]
>
>
>
> ---------------------------------------------------------------------
> 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