If you want dev synchronized with production use transactional replication.
If you need an image of production use a backup and restore.
--
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] "Abhi" <Abhi@discussions.microsoft.com> wrote in message
news:8340F8B6-1C33-45C1-B49E-8E5F85ED575C@microsoft.com...
> Hi,
>
> We are planning to move our production database to a test server and were
> thinking what would be the right way to do it? We want to replicate the
> data
> nightly. Would peer-to-peer replication be the way to do it?
>
> Thanks,
>
> Abhi