Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bruceeanderson
Starting Member
1 Post |
 Posted - 2008-09-10 : 10:28:30
|
| We have a MS SQL 2500 database at a datacenter. We want to put a copy of this database in our corporate office and use it “read only” for research purposes. Every night, we want to do an automated incremental update of our copy with the changes that have occurred during the day; nothing from the office ever goes back to the datacenter. We have a T1 connection to the datacenter, so bandwidth is an issue. 200 tables, 35 GB. Is this task best handled as publisher/subscriber with snapshots? Are snapshots incremental, or will we be sending everything every night? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-10 : 12:57:00
|
| One option is to database mirror to the corporate office and then perform a nightly snapshot on the mirror database so that you can query it. By using this method, you could choose to do a snapshot outside of the nightly schedule if you need more up-to-date data.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Maintaining a Read Only copy of database