Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I wish to schedule a copy from my production database into two other databases.

The databases are located on same server (instance?). The databases are currently backed up to server hard drive every night and basing a solution on this backup would be fully satisfactory.

What is the best way to do this?

Any comments appreciated,

Anders, Denmark

share|improve this question

2 Answers 2

up vote 2 down vote accepted

Schedule a restore from the backup to the development database? It is not that hard. Use SQL Server Agent for that ;)

share|improve this answer
    
Very simple answer - but sometimes that just what you need ;-) I got it to work in first attempt... –  Anders Juul May 10 '10 at 10:14

I think snapshot replication would fit your needs. Please refer here for further details:

http://msdn.microsoft.com/en-us/library/ms151198.aspx

Regards, D.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.