Post reply

Refreshing the Reporting database from Production database every 2 hour

  • June 13, 2008 at 2:52 am

    #71438

    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.

  • June 13, 2008 at 8:33 am

    #828546

    1. Replication: SnapShot or Transactional

    2. Log Shipping.

    3. Mirroring + Database SnapShot (SQL 2005)

  • June 16, 2008 at 7:16 pm

    #829559

    Thank you for the reply. Could you please suggest me the best way among these, so that it wont slow down performance the production database.

  • June 17, 2008 at 11:14 am

    #829940

    Go for Transactional Replication.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply