December 16, 2005 at 9:06 pm
I have got two sql servers , out of which one is used only for reporting purposes.
I update the reporting server by restoring the backup from the live server
Is there any process by which i could automate this
December 17, 2005 at 11:25 am
You can either:
1) Look into implementing log shipping between the production and the reporting server..a lag of 15 minutes or whatever interval you want for the sync. up will work fine. Same goes for replication strategies.
2) If you want to stick with back-up and restore, then also you can automate the process by deciding on the timings and co-ordinating between these steps :
a) Taking back-up on the production server (have a proper back-up strategy - full back-up of large database would take time so look into full back-up + differential back-up + transaction log back-up strategy...your recovery model also governs this).
b) Ftp'ing the file across to the reporting server.
c) A job can then be kicked off on the reporting server that kills any open connections to the database on the reporting server and then restores the database/transaction log as appropriate.
There are a couple of creative ways to achieve this for the #2.
Hth.
December 20, 2005 at 12:58 pm
If you are restoring the reporting database from live server just to get the data, and you do not need all whole live database for reporting. Then try to create a DTS package which imports the data required for reporting, not all the data from live database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply