Showing posts with label advantages. Show all posts
Showing posts with label advantages. Show all posts

Friday, March 9, 2012

replication - log shipping

Hi,
how to tell which is better Replication or log shipping?, what are the advantages / disadvantages using each.
if I want to select one of these what all I need to consider?
Please reply.
RamRefer to books online for those 2 topics as a first hand information.

It depends on your environment, if you explain bit about it can give suggestion.

Saturday, February 25, 2012

Replication

Hello,
Whats's the utility / advantages of the "Transactional publication with
updatable subscriptions"
thanks for your help!!!
nico
"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:1C221973-1029-4380-8C24-A8C55817567F@.microsoft.com...
> Hello,
> Whats's the utility / advantages of the "Transactional publication with
> updatable subscriptions"
> thanks for your help!!!
>
Transactional replication starts with a snapshot. Thereafter only the
changes are replicated (which will typically mean less network traffic /
more frequent updates / less latency between different copies of the
database).
Updateable subscriptions means that the destination servers (subscribers)
can update the data on their own SQL Servers. SQL server will update it
locally and at the same time on the Publisher database, so that the changes
can then be replicated out to the other subscribers. This is done via a
distributed transaction.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 08/10/2004

Replication

Hello,
Whats's the utility / advantages of the "Transactional publication with
updatable subscriptions"
thanks for your help!!!
nico"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:1C221973-1029-4380-8C24-A8C55817567F@.microsoft.com...
> Hello,
> Whats's the utility / advantages of the "Transactional publication with
> updatable subscriptions"
> thanks for your help!!!
>
Transactional replication starts with a snapshot. Thereafter only the
changes are replicated (which will typically mean less network traffic /
more frequent updates / less latency between different copies of the
database).
Updateable subscriptions means that the destination servers (subscribers)
can update the data on their own SQL Servers. SQL server will update it
locally and at the same time on the Publisher database, so that the changes
can then be replicated out to the other subscribers. This is done via a
distributed transaction.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 08/10/2004

Replication

Hello,
Whats's the utility / advantages of the "Transactional publication with
updatable subscriptions"
thanks for your help!!!
nico"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:1C221973-1029-4380-8C24-A8C55817567F@.microsoft.com...
> Hello,
> Whats's the utility / advantages of the "Transactional publication with
> updatable subscriptions"
> thanks for your help!!!
>
Transactional replication starts with a snapshot. Thereafter only the
changes are replicated (which will typically mean less network traffic /
more frequent updates / less latency between different copies of the
database).
Updateable subscriptions means that the destination servers (subscribers)
can update the data on their own SQL Servers. SQL server will update it
locally and at the same time on the Publisher database, so that the changes
can then be replicated out to the other subscribers. This is done via a
distributed transaction.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 08/10/2004