SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag Replication Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 7, 2000 (44)     Lock and Connection Management (5)     Distributed Queries (2)     Indexing (1)    
Miscellaneous (21)     Index Management (4)     Monitoring (2)     Installation (1)    
Maintenance and Management (17)     SQLInsider Scripts (4)     Performance Tuning (2)     OpenXML (1)    
Backup / Restore (11)     Strategies (4)     Security (2)     Scripts (1)    
Administering (10)     Disaster Recovery (3)     SQL Server 2005 Express (2)     SS2K5 - Replication (1)    
Configuring (9)     Mail (3)     SQL-DMO (2)     Stored Procedures (1)    
T-SQL Aids (9)     Performance Tuning and Scaling (3)     T-SQL (2)     Triggers (1)    
Data Warehouse (7)     SQL Server 6.5 (3)     Basic Querying (1)     UpdateGrams (1)    
Backup and Recovery (6)     Visual Basic 6 (3)     DTS (1)     User-Defined functions (1)    
Programming (6)     ADO (2)     English Query (1)     XML (1)    
SQL Server 2005 (6)     Availability (2)     High Availability (1)     XSL (1)    
   Items 1 to 20 of 129    Next 20 >>
 

Log Shipping vs. Replication

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.   Read more...
By Paul Ibison 2008/06/27 (first posted: 2004/06/17) | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 30,894 reads

SQL 2005 - List value of 'Not For Replication'

Script will list all identity columns with valus of 'Not for Replication'  Read more...
By Sandeep Saretha 2008/05/13 | Source: SQLServerCentral.com | Category: Replication
Rating: (not yet rated) |  Discuss |  Briefcase | 179 reads

SQL Server 2005 Express Edition - Part 21 - Using Replication Management Objects

Recent installments of this series have demonstrated SQL Server 2005 Express Edition's replication characteristics by taking advantage of replication-specific executables and T-SQL code combined with Windows Synchronization Manager and Web Synchronization technologies. This article explores another method of reaching the same goal, which involves Replication Management Objects (RMO).  Read more...
By Additional Articles 2008/04/30 | Source: Database Journal | Category: Replication
Rating: (not yet rated)  Rate this |  Briefcase | 986 reads

Tracer Token

Measure Latencies in Replication implemented using SQL Server 2005  Read more...
By Mohan Kumar 2008/04/24 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 1,915 reads

High Availability (DR) Using SQL Server 2005 Transactional Replication

One of the four high availability technologies in SQL Server is replication, though this can be very cumbersome to setup and get working. Longtime author Paul Ibison looks at how this has changed from SQL Server 2000 to 2005 and what you should consider before setting this up.  Read more...
By Paul Ibison 2008/04/17 | Source: SQLServerCentral.com | Category: High Availability
Rating: |  Discuss |  Briefcase | 4,302 reads

The Architecting Magic Behind Taking Mash Ups Offline

While most of the complexity you encounter in synchronization efforts will be unique to your application and infrastructure, synchronization works best when it's designed to be a core feature in each data store.  Read more...
By Additional Articles 2008/03/21 | Source: DevX | Category: Replication
Rating: (not yet rated)  Rate this |  Briefcase | 797 reads

How to Break Replication

David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.  Read more...
By David Poole 2008/03/06 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 5,743 reads

Snapshots - Part 1

Longtime replication expert Andy Warren takes a look at the initial snapshots involved with replication and dives into an explanation of what's involved.  Read more...
By Andy Warren 2008/02/26 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 1,725 reads

Init From Backup

Replication can be confusing to many new SQL Server DBAs and some of the optmizations are not well described in Books Online. SQL Server replication expert and trainer Andy Warren brings us a technique for initializing replication without a snapshot.  Read more...
By Andy Warren 2008/02/07 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 2,385 reads

Peer to Peer

By 2008/01/21
Rating: (not yet rated) |  Discuss |  Briefcase | 1,908 reads

SQL Server 2005 Express Edition - Part 14 - Replication Support

SQL Server 2005 Express Edition's small footprint and free-of-charge use has some negative implications, imposing restrictions on functionality available in the Standard or Enterprise editions. This is especially conspicuous in the case of replication, which we will explore starting with this installment.  Read more...
Rating: (not yet rated)  Rate this |  Briefcase | 1,254 reads

Replication Queue Agent

By 2008/01/03 | Category: Replication
Rating: (not yet rated) |  Discuss |  Briefcase | 1,914 reads

Replication Framework

By 2007/12/27 | Category: Replication
Rating: (not yet rated) |  Discuss |  Briefcase | 1,880 reads

Replication Merge Agent

By 2007/12/20 | Category: Replication
Rating: (not yet rated) |  Discuss |  Briefcase | 2,095 reads

Replication Working Director

By 2007/12/14 | Category: Replication
Rating: (not yet rated) |  Discuss |  Briefcase | 1,784 reads

Altering a column on a Replicated Table

SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns.   Read more...
By Paul Ibison 2007/11/30 (first posted: 2005/01/19) | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 22,195 reads

Replicate Stored Procedure Execution

Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.  Read more...
By Andy Warren 2007/11/05 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 3,071 reads

Replication Statement Delivery Options - Part 2

Continuing with his look at transactional replication, Andy Warren looks at the various delivery options with a detailed analysis of what happens under various configurations.   Read more...
By Andy Warren 2007/09/25 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 1,789 reads

Replication Statement Delivery Options - Part 1

Replication is one of the more useful features in SQL Server and can handle a wide variety of tasks based on his configuration. SQL Server expert Andy Warren takes a look at some of the default transational replication options in this article and what they mean.   Read more...
By Andy Warren 2007/09/24 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 2,403 reads
   Items 1 to 20 of 129    Next 20 >>
 
Most popular

How to Break Replication

David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.  Read more...
By David Poole 2008/03/06 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 5,743 reads

Tracer Token

Measure Latencies in Replication implemented using SQL Server 2005  Read more...
By Mohan Kumar 2008/04/24 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 1,915 reads

Replicate Stored Procedure Execution

Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.  Read more...
By Andy Warren 2007/11/05 | Source: SQLServerCentral.com | Category: Replication
Rating: |  Discuss |  Briefcase | 3,071 reads