sql server replication: 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,

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.

--
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



[quoted text, click to view]