Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Refreshing the Reporting database from Production database every 2 hour Expand / Collapse
Author
Message
Posted Friday, June 13, 2008 2:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 6:10 AM
Points: 59, Visits: 373
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.
Post #516479
Posted Friday, June 13, 2008 8:33 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 7, 2014 12:18 PM
Points: 413, Visits: 1,438
1. Replication: SnapShot or Transactional
2. Log Shipping.
3. Mirroring + Database SnapShot (SQL 2005)
Post #516756
Posted Monday, June 16, 2008 7:16 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 6:10 AM
Points: 59, Visits: 373
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.
Post #517965
Posted Tuesday, June 17, 2008 11:14 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 7, 2014 12:18 PM
Points: 413, Visits: 1,438
Go for Transactional Replication.
Post #518444
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse