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 |
|
creane
Starting Member
11 Posts |
 Posted - 2003-08-27 : 05:24:27
|
| Hi, Ive a few questions and would be grateful for any assistance/comments from experience as Ive not that much dba experience , we have 3 servers all containing sql 2000 standard edition, two (prod and standby) located in the U.S. and Im hoping to set up the third as a reporting server locally in Europe...presumably having the data close as possible and as current as possible for reporting?...We dont have the resources to implement clustering so presumably I envisage keeping the standy server using either Log shipping or replication (i think log shipping being the best approach here?). My question is whats the best approach for getting the data across the network from the U.S to Europe (differing domains but internal network).. Is transactional replication albeit push or pull the best approach to get the data across, ie. with log shipping it seems that you will have to copy across the bckups nightly using xcopy /ftp transaction log backups scheduled, does transactional replication just propogate the changes and not the entire backup daily. if its just the changes does it note just the changes made to the standby server every day and just replicate these across? (i.e. a backup restore is done daily with log shipping to the standby server..With transactional replication will it note that some of this data has been replicated already..) Any help greatly appreciated..Eric |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-27 : 12:39:06
|
| Replication would be the method that I would recommend. If you use log shipping, the database is either in standby mode, meaning read_only, or it is not available at all. So if any of your reports use temporary tables, you will not be able to run them. Replication just applied the changes to the destination server. It does not copy the daily backups across to the other server.Tara |
 |
|
|
|
|
|
trasactional replication and log shopping