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 |
|
p.shaw3@ukonline.co.uk
Posting Yak Master
103 Posts |
 Posted - 2007-03-22 : 09:27:33
|
| Hi,This is a 2 part question really:I have a web server running SQL Server 2000 Workgroup edition and I need to maintain a near up to date copy of a database from this server onto an office server running SQL Server 2000 Enterprise edition.Firstly, is it possible to log ship between these 2 servers when only the SQL Server that receives the data is Enterprise edition?Secondly, if this is possible, would Replication be a better option in terms of system resources, data transfer volume etc. (bearing in mind that server A is a functional web server) and if so, which type of Replication would you advise? It seems to me that only Transactional replication would suit my needs but I am worried that this would be too intensive. This is why I want to explore the Log Shipping route.Any suggestions would be greatly appreciated. |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-23 : 15:33:24
|
| If you want up to date copy of the database then replication is the best option because in log shipping users will be killed to restore logs depends on how often the log restore runs....For transactional replication every table has to have PK but you can do procedure execution replication instead of table to reduce the overhead...Replicating Stored Procedure Execution http://www.sql-server-performance.com/mak_replicating_sp_execution.aspMohammedU |
 |
|
|
|
|
|
Log Ship or Replicate?