Home Forums SQL Server 7,2000 Administration Refreshing the Reporting database from Production database every 2 hour RE: Refreshing the Reporting database from Production database every 2 hour
Wildcat
SSCarpal Tunnel
Points: 4774
More actions
June 13, 2008 at 8:33 am
#828546
1. Replication: SnapShot or Transactional
2. Log Shipping.
3. Mirroring + Database SnapShot (SQL 2005)