SQLServerCentral / Administration / SQL Server 7,2000 / Refreshing the Reporting database from Production database every 2 hour / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 00:19:46 GMT20RE: Refreshing the Reporting database from Production database every 2 hourhttp://www.sqlservercentral.com/Forums/Topic516479-5-1.aspxGo for Transactional Replication.Tue, 17 Jun 2008 11:14:38 GMTWildcatRE: Refreshing the Reporting database from Production database every 2 hourhttp://www.sqlservercentral.com/Forums/Topic516479-5-1.aspxThank you for the reply. Could you please suggest me the best way among these, so that it wont slow down performance the production database.Mon, 16 Jun 2008 19:16:18 GMTvirgoRE: Refreshing the Reporting database from Production database every 2 hourhttp://www.sqlservercentral.com/Forums/Topic516479-5-1.aspx1. Replication: SnapShot or Transactional2. Log Shipping.3. Mirroring + Database SnapShot (SQL 2005)Fri, 13 Jun 2008 08:33:07 GMTWildcatRefreshing the Reporting database from Production database every 2 hourhttp://www.sqlservercentral.com/Forums/Topic516479-5-1.aspxHi 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.Fri, 13 Jun 2008 02:52:06 GMTvirgo