Browse by Tags

RSS Feeds

replication (RSS)

Subscriptions marked as inactive

I have two sql2005 servers, both at same sp level. At first glance, the publisher looks to be up with no issues. When I view the replication monitor, I see the following error: The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated...

Posted to SQL Server 2008 Replication (Forum) by kdefilip on 01-18-2010
SQL Server upgrade practices - choose optimal upgrade options

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 the databases that are involved in the replication...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 10-26-2009
SQL Server - Types of replication in simple terms that relates to architecture

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 models in simple terms, as the originator got confused...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 09-20-2009
FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 08-26-2009
Removal of SQL DMO in future release of SQL Server - take action now!

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 using this feature in new development work, and...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 08-18-2009
SQL Server Peer-to-Peer replicaton - how to achieve scalability and availability

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. The primary resource of replication satisfies...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 07-28-2009
Unable to run SQL*PLUS. Make certain that a current version of the Oracle client code is installed at the distributor.

The error subject line is caused due to issues with Oracle Client and Networking connection privileges. By default when you have SQL replication setup to an Oracle client then the account under which SQL Server instance runs on the Distributor must be granted read and execute permissions for the directory...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 06-18-2009
Cannot Truncate Transaction Logs when Snapshot replication is enabled

I am currently experiencing significant difficulties truncating trancation logs on a database which is being replicated to another sql server. The database is running in a fresh install of SQL2005 64bit and has no service packs installed. The problem does not occur if I remove all replication components...

Posted to SQL Server 2005 General DBA Questions (Forum) by Mark247 on 06-02-2009
Re: Transaction replication over VPN

Hi, I would suggest you to go through the articles http://msdn.microsoft.com/en-us/library/ms151172(SQL.90).aspx , http://msdn.microsoft.com/en-us/library/ms152569(SQL.90).aspx and http://www.sql-server-performance.com/articles/dba/replication_across_internet_p1.aspx I have configured merge replication...

Posted to SQL Server 2005 Replication (Forum) by ghemant on 05-28-2009
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)

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 SQL Server 2005 version cluster as a publisher (out...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 02-11-2009