Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Replication, SQL Server 2005 Rss

   Items 1 to 12 of 12   
 

Issue with SQL Server 2K5 SP3 CU5

In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out one issue / bug we found with CU5.  Read more...
By Jeffrey Yao 2009/09/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,505 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 (ha)
Rating: |  Discuss |   Briefcase | 7,713 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 | 3,643 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 | 5,133 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 | 3,856 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 | 4,025 reads

Managing identity columns with replication in SQL Server

There are some issues associated with managing identity columns with replication in your SQL Server database. As with previous releases of software, SQL Server 2005 requires that database administrators use special care when replicating tables with identity columns.  Read more...
By Additional Articles 2007/09/07 | Source: SearchSQLServer | Category: replication
Rating:  Rate this |   Briefcase | 2,166 reads

DDL Replication in SQL Server 2000 and 2005

How schema changes can propogate in SQL Server 2005's Replication Architecture.   Read more...
By Additional Articles 2007/07/16 | Source: SQL Server Performance | Category: replication
Rating:  Rate this |   Briefcase | 2,081 reads

SQL Server Replication Crib Sheet

Robyn Page delves into all the things you need to know, rather than want to know, about SQL Server replication.  Read more...
By Additional Articles 2007/05/30 | Source: SimpleTalk | Category: replication
Rating:  Rate this |   Briefcase | 4,711 reads

Replicating Identity Columns

SQL Server 2005 has changed replication dramatically and one of the changes is that subscriber tables have the identity column. SQL Server guru Andy Warren takes a look at what impact this has on transactional replication.   Read more...
By Andy Warren 2007/03/28 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 7,907 reads

SQL 2005 Web Synchronization for Merge Replication

Web synchronization in SQL 2005 enables highly secure synchronization of your merge subscriptions. This feature has been in high demand for many years, and Microsoft has finally delivered. This feature is difficult to deploy, however, so Hilary Cotter provides a tutorial on how to set up this complex feature.   Read more...
By Additional Articles 2006/11/17 | Source: InformIT | Category: replication
Rating:  Rate this |   Briefcase | 2,136 reads

SQL Server 2005 Transactional Replication Agents

SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. SQL Server 2005 exposes some parameters through graphical interface that were available only from command line or through agent job steps in previous releases. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.   Read more...
By Additional Articles 2006/11/07 | Source: InformIT | Category: replication
Rating:  Rate this |   Briefcase | 1,967 reads
   Items 1 to 12 of 12   
 
Tags
sql server 7 (2)    
blogs (1)    
high availability (ha) (1)