sql server Replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mecn - 30 Jul 2008 20:53 GMT

Hi,

The 3 kinds of replication for SQL2000 compare to log shipping.

My question is,
1. log shipoping needs to kill all connections before restore log file to a
standby box --- not good for using of reporting and other data lookup
2. SQL native transactioal replication are ok for reporting? does it need to
kill the connections as well?

Thanks

Reply to this Message

Daniel Jameson - 31 Jul 2008 23:45 GMT

Mecn,

I don't know about the logshipping connection issue, but I know that
replication does not affect connections.

Log shipping is a database level operation, so all changes are transferred,
including altered tables and stored procedures.

Replication is a table level operation, so only data changes in published
tables (and indexed views) are transferred. If you need to change a
published table, you need to interrupt replication, make your changes, and
then resume your replication after appropriate snapshots are generated and
delivered to the subscriber.

Signature

Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message