bothaellen (10/27/2010)
We have a production server running at a remote site. We would like to restore Transactional backups from the production server to the Development Server Database every night so that the data on the Development server is the same as the Production server .
You're talking about log shipping. There's a good description of it in BOL and tons of articles on the web. Also check out "Database Mirroring and Log Shipping" in BOL to see if mirroring might better fit your needs.
Greg