How to automate backup and restore from Live server to Test server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dondiego - 28 Sep 2006 22:30 GMT

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

Reply to this Message

Hilary Cotter - 29 Sep 2006 02:50 GMT

You have many options here. A simple backup restore will work, or log
shipping and only apply the logs on a weekly basis. You can also use
snapshot or transactional replication.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hello,
> I need to automate the replication from live server to test server (i.e
[quoted text clipped - 5 lines]
>
> Don Diego

Reply to this Message