Automate backup and restore from Live to Test environment

microsoft.public.sqlserver.programming

28 Sep 2006 9:15 PM

dondiego

Hello,
I need to automate the replication from live server to test server (i.e
weekly backup of a live server followed by restore to the test server).

Any pointers would be greatly appreciated.

Thanks in advance,

Don Diego