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

   Items 1 to 20 of 50    Older >>
 

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,492 reads

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 published: 2004/06/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 59,043 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 published: 2005/01/19) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 35,031 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 | 3,995 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,646 reads

A Transactional Replication Primer

Setting up replication can be fairly easy, but deviating from the follow-the-wizard approach can be tricky. New author Claudia Rego brings us a primer on setting up transactional replication without requiring an initial snapshot.   Read more...
By Claudia Rego 2006/11/20 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 8,425 reads

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 published: 2004/06/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 59,043 reads

Handling Conflicts in Merge Replication

Merge replication is probably not used as often as it could be, mainly because of the potential complexities of this tool. New author Satia Madimchetty brings us a great article that simplifies one part of this SQL Server feature, the conflict resolution issues.   Read more...
By Satia Madimchetty 2006/02/13 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 10,813 reads

Moving Replicated Databases

Replication is a great tool, but it has a number of restrictions on what you can do with replicated databases. Typically you cannot easily move a replicated database, but our own Andy Warren brings us a technique that can get around this.   Read more...
By Andy Warren 2006/02/01 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 14,126 reads

SQL 2000 Replication Architecture

New author! Mahesh presents a solid overview of the replication architecture of SQL 2000.   Read more...
By Mahesh Kodli 2005/12/02 (first published: 2003/10/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 44,423 reads

Adventures in Replication

SQL Server 2000 replication is the easiest so far to setup and work with. However there are some areas that you can get yourself into trouble with if you are not careful. New author Chris Rock brings us a few lessons learned in getting replication working with a remote office.   Read more...
By Chris Rock 2005/08/22 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 9,637 reads

The identity crisis in replication

This article discusses three common problems DBAs are likely to encounter when columns have the identity property, which is defined as an attribute of int, smallint, bigint, decimal, numeric or tinyint columns that will auto-increment their value when data is inserted. These problems are humorously referred to as the identity crisis.   Read more...
By Additional Articles 2005/07/28 | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 3,328 reads

Multi-User Considerations in Data Synchronization for SQL Server 2005

Gain a better understanding of how to develop your SQL Server Mobile applications to handle multi-user access and data synchronization with Microsoft SQL Server 2005.  Read more...
By Additional Articles 2005/04/04 | Source: MSDN Communities | Category: replication
Rating:  Rate this |   Briefcase | 1,773 reads

Programming Replication from Heterogeneous Data Sources

Microsoft® SQL Server™ enables third-party products to become Publishers within the SQL Server replication framework. The Replication Distributor Interface allows replication from heterogeneous databases that provide 32-bit OLE DB drivers to Subscribers running SQL Server 2000. Heterogeneous data sources include: * Oracle databases * DB2 databases * Microsoft Access databases * Other databases that comply with SQL Server ODBC or OLE DB Subscriber requirements  Read more...
By Additional Articles 2005/03/16 | Source: MSDN Communities | Category: replication
Rating:  Rate this |   Briefcase | 1,980 reads

Replicating Identity columns in SQL Server - Customizing replication

When transactional replication is used for high availability purposes, such as if you want the applications to access the replicated server when the primary database server fails, one of the hurdles SQL Server database administrators face when configuring replication is tables with identity columns. In this article, I am going to discuss how to customize the replication in order to make the subscription database look identical to the publishing database, so that when there is a failure in the primary server, it is simple to fail over to the subscription database.   Read more...
By Additional Articles 2005/03/07 | Source: Database Journal | Category: replication
Rating:  Rate this |   Briefcase | 2,466 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 published: 2005/01/19) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 35,031 reads

Merge Replication - Manual Range Handling

SQL Server 2000 replication is a great feature, but it can cause some headaches at times. Since the use of identities is something many people take advantage of, learning to handle these in a replication scenario is critical. Author Paul Ibison has done extensive work with replication and brings us two techniques to help manage the ranges of values.   Read more...
By Paul Ibison 2005/01/13 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 12,510 reads

Transactional replication performance tuning and optimization

Transactional replication is a type of replication provided by SQL Server 2000 that allows data modifications to be propagated incrementally between servers in a distributed environment.   Read more...
By Additional Articles 2005/01/07 | Source: MSDN Communities | Category: replication
Rating:  Rate this |   Briefcase | 3,560 reads

Diagnosing and Troubleshooting Slow Partitioned Merge Processes

Learn how to achieve scalable, high-performance merge replication applications. (White Paper)  Read more...
By Additional Articles 2004/12/15 | Source: MSDN Communities | Category: replication
Rating:  Rate this |   Briefcase | 1,436 reads

Duplicate Key Inserted Error During Replication

If you allow users write access to replicated tables on the subscriber, you can run into cases where a record is inserted on the wrong server - which will result in a replication stopping error if the same primary key is later inserted on the publisher. Find out how to fix it without pushing a new snapshot.   Read more...
By Andy Warren 2004/10/15 (first published: 2001/05/04) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 8,458 reads
   Items 1 to 20 of 50    Older >>
 
Tags
administration (10)    
configuring (9)    
miscellaneous (8)    
backup / restore (6)    
programming (6)    
performance tuning (4)    
strategies (4)    
disaster recovery (dr) (3)    
sql server 6.5 (3)    
visual basic 6 (3)    
ado (2)    
availability (2)    
distributed queries (2)    
monitoring (2)    
security (2)    
sql server 2005 (2)    
sql-dmo (2)    
t-sql (2)    
dts (1)    
english query (1)    
indexing (1)    
installation (1)    
openxml (1)    
scripts (1)    
stored procedures (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)