SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : replication

SQL Server upgrade practices - choose optimal upgrade options

Mon, 26 Oct 2009 12:18:00 GMT

SQL Server Upgrade task needs a thorough planning and testing before you deploy the process in production environment. In this regard when performing an upgrade to a replicated environment, DBAs must make sure that all changes have been applied to all...(read more)

SQL Server - Types of replication in simple terms that relates to architecture

Sun, 20 Sep 2009 15:54:00 GMT

I tend to get emails that relates to SQL Server questions from the user, by default I suggest them to post on the forums to get quicker response and do reply in simple terms. One of the them I got recently asking about how can I explain the replication...(read more)

Removal of SQL DMO in future release of SQL Server - take action now!

Tue, 18 Aug 2009 07:52:00 GMT

If you remember about SQL Server 2005 installation & feature documentation SQL-DMO has been referred as backward compatibility, and that feature will be removed in a future version of SQL Server. So the documentation has been heavy on users to avoid...(read more)

SQL Server Peer-to-Peer replicaton - how to achieve scalability and availability

Tue, 28 Jul 2009 07:39:00 GMT

Replication will be very handy to distribute the load of application when you have large scale of data management, as it evolved from SQL Server 6.0 version the transactional replication is first baby that was primarily used to support reporting applications...(read more)

The operation could not be performed because OLEDB provider "SQLNCLI" for linked server "repl_distributor" was unable to begin a distributed transaction (Microsoft SQL Server, Error 7391)

Wed, 11 Feb 2009 07:32:00 GMT

The above error clearly specifies the connectivity issues between 2 instance, to give more information I have been dealing with this problem at a client's place. The setup that was configured and deployed was a very complicated replication between...(read more)

Strategy to provide Availability and Scalability - SQL Server Replication

SqlServer-QA.net — Wed, 07 Jan 2009 07:36:00 GMT

Scalability is the potential for the database to maintain performance goals while adapting to increased workloads. At the same time Availability is another important factor to keep up this scalability which involves scale-up strategies of upgrading hardware...(read more)

sp_replwriterovarbin - New SQL Server Injection-Based Attack Found

SqlServer-QA.net — Wed, 17 Dec 2008 07:10:00 GMT

Another security vulnerability or rather call in the sense of security experts that " A zero day vulnerability has been reported in SQL Server "! Though its a not serious flaw or problematic loophole to worry but still its a security flaw in...(read more)

Replication and Database Mirroring - things to take care and best practices to administer the environment

SqlServer-QA.net — Mon, 15 Dec 2008 11:37:00 GMT

Replication and Database Mirroring are the ones which can provide high availability option without an extra cost what it implies on a Clustering setup. So in this scenario Database mirroring can be used in conjunction with replication to provide availability...(read more)

Replication Monitor enhancements in SQL Server 2008

SqlServer-QA.net — Fri, 17 Oct 2008 08:07:00 GMT

Replication Monitor is an useful tool that gives information about publisher view of all replication activity including status information for publications and subscriptions. When you load the replication monitor by default it will display warnings only...(read more)

SQL Server 2008 - Replication and Filestream, are both supported together?

SSQA.net — Mon, 26 May 2008 09:01:00 GMT

Ok, replication concepts and technology has been continuing since the olden days (version 70) within SQL Server journey. To talk about new features within SQLServer 2008 comapring to the previous versions, FILESTREAM where much of data is created every...(read more)

SQL Server Replication - resolving too many snapshots issues?

SSQA.net — Tue, 15 Apr 2008 11:15:00 GMT

In case you have many snapshots generated within your Replication setup and having troubles in finding what kind of scheduled job is running during the time of snapshot publication. By default you coudl take help of system catalog MSsnapshot_agents and...(read more)

SQL Server 2005 - specific roles for replication agents

SSQA.net — Fri, 22 Feb 2008 20:10:00 GMT

Whenever the replication is configured, a set of agent profiles is installed on the Distributor, thsi profile will have a set of parameters that are used each time an agent runs. In addition to this the replication provides a default profile for each...(read more)

Replication FAQ - how to know Distributor and Publisher with scripts

SSQA.net — Tue, 19 Feb 2008 22:45:00 GMT

A newbie set of question that how to know the whether the current server is distributor or publisher? Any pre-defined script to know any other publishers that are using as Distributor? Well, there are such pre-defined scripts and stored procedures are...(read more)

SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

SSQA.net — Wed, 13 Feb 2008 11:02:00 GMT

One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout...(read more)

SQL Server replication FAQ and important measures to consider when replication performance is sufferred

SSQA.net — Thu, 07 Feb 2008 15:41:00 GMT

Here we are going to highlight the majority of tasks you need to perform whenever user complains or you observe about SQL Server Replication performance is affected, adversly. For any performance tuning issues there will be other factors involved including...(read more)

Real-time replication with SQL Server reporting, strategies and resolution to the problems?

SSQA.net — Wed, 30 Jan 2008 18:23:00 GMT

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that...(read more)

Transactional Replication Snapshot Issues - useful resources to resolve

SSQA.net — Wed, 16 Jan 2008 07:08:00 GMT

When you have problems with SQL Server replication where the transactional replication is common case in setting up, eventually you will have problems when the data is growing up and any sudden changes in the ETL will also have affect on replication process...(read more)

How to perform Replication within different domains?

SSQA.net — Tue, 18 Dec 2007 18:15:00 GMT

Got a question via email asking to configure Transactional Replication between two servers with in SQL Server 2005. By all means I would like to refer this KBA http://support.microsoft.com/kb/321822 for replication between HOW TO: Replicate Between Computers...(read more)

How to find subscriber is not getting upto date data?

SSQA.net — Sat, 15 Dec 2007 01:18:00 GMT

Run the following TSQL to get details of troubled subscribers that are not getting upto date data: select agent_id from msdistribution_status group by agent_id having sum(undelivCmdsInDistDB) >1000 order by sum(undelivCmdsInDistDB) desc...( read more...(read more)

SQL Server Replication - presentation from Scottish Area SQL Server User Group

SSQA.net — Wed, 12 Dec 2007 22:04:00 GMT

As a part of regular monthly meetings from Scottish Area SQL Server user group [ Scottish Area SQL Server User Group: Wednesday 12th December 18:30 - 21:00 : Edinburgh ] I have given a presentation on SQL Server Replication, type of SQL Server Replication...(read more)