Hi Sql Gurus!!
Can you plz let me know the best method to refresh Reporting Database from Production database.
And this need to be scheduled job, which will be refreshing reporting database every 2 hour.
Since I need to refresh the reporting database every 2 hours I don't think database backup and restore will be a gud idea.
So can any one plz suggest a ideal method for pulling the data from Production database to Reporting database every 2hrs.