It depends what your reason for duplicating your database to another server.
If serverB would be used for reporting, so serverA's resources are spared, then use replication. (serverB will not be useable by anybody during both data and log restores)
If serverB is only used as a hotstandby for serverA then use log shipping
Yes you can set log shipping up on std edition - http://www.sql-server-performance.com/sql_server_log_shipping.asp. This page will give a good idea, and from there you can customize to your situation.
I would think network traffic would be similar, since the same amount of data has to go between servers. Could be wrong? Maybe shipping has less data, cause only backups are traveling across the network? Again, could be wrong in my thinking.
Personally log shipping is easier for me to maintain and setup than replication. Replication has all sorts of issues when altering table and database schemas, log shipping catches all your changes - have your server on full recovery mode though.
-----Original Message-----
From: Natalia Brett [mailto:mssqldba-ezmlmshield-x77707354.[Email address protected]
Sent: Tuesday, February 22, 2005 12:06 PM
To: LazyDBA Discussion
Subject: Log Shipping or Transactional replication[Scanned]
Hello all,
Can somebody tell me ...
- what is the difference between Log Shipping or Transactional replication (apart of implementation)?
- is it possible to build Log Shipping on SQL2000 Standard edition?
- What is impact on the network traffic from Log Shipping or from Transactional replication?
Thanks,
Natalia
The information within this e-mail is confidential and intended solely for the use of the recipient(s). If you are not the intended recipient then please notify Natalia Brett via email at Natalia.[Email address protected] or by telephone on +44(0)1244 319912. Then delete the email from your system. Please do not read, copy, print, forward, disclose, or use the information contained within this email. Note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Aktiv Kapital. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
Aktiv Kapital (UK) Ltd
Merchants House
Hamilton Place
Chester
CH12BE
UK
www.AktivKapital.co.uk
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page