Restoring and Backing between two server
I have 2 servers(production and reporting) with Server 2008 R2 and I have installed MSSQL 2008 database on each of the servers. One of the server is production server where my ERP application is being used by my users and I have this second server which I want to use for reporting purpose. Now I want to be able to backup the production db and restore the second server with this backup from the production server. I want this to be done automatically every 2 hours daily. At present I have to do this manually. So I want to know will SQL Backup do this job for me. If yes then I need to install SQL Backup on the production or reporting server.