Refreshing the Reporting database from Production database every 2 hour

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Refreshing the Reporting database from...

Refreshing the Reporting database from Production database every 2 hour

Rate Topic

Display Mode

Topic Options

Author

Message

virgo

Posted Friday, June 13, 2008 2:52 AM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 3:54 AM
Points: 51, Visits: 185

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

Wildcat

Posted Friday, June 13, 2008 8:33 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:10 PM
Points: 307, Visits: 1,390

1. Replication: SnapShot or Transactional
2. Log Shipping.
3. Mirroring + Database SnapShot (SQL 2005)

Post #516756

virgo

Posted Monday, June 16, 2008 7:16 PM

Valued Member

Group: General Forum Members
Last Login: Saturday, May 18, 2013 3:54 AM
Points: 51, Visits: 185

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

Wildcat

Posted Tuesday, June 17, 2008 11:14 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 10:10 PM
Points: 307, Visits: 1,390

Go for Transactional Replication.

Post #518444

« Prev Topic | Next Topic »

Permissions