Hi Hugh!
Just need more clarification on this as you said if serverB is used for
reporting then Replication should be used but logshipping can be used as
well by removing unchecking the check box for "Terminate users". It just
puts the database in read only mode (stand by mode), it can be used as
well and at critical times can act as Primary server as well.

In this case this as well as act as Replication!

-----Original Message-----
From: Hugh du Toit
[mailto:mssqldba-ezmlmshield-x42917609.[Email address protected]
Sent: Tuesday, February 22, 2005 2:27 PM
To: LazyDBA Discussion
Subject: RE: Log Shipping or Transactional replication[Scanned]


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]





---------------------------------------------------------------------
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