SQL Server 2008 - scheduled copy of production database into test and development databases

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

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

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.