Other SQL Server Blogs around the Web

Browse by Tags

• 2005
• agent
• beginners
• best practices
• broker
• ce
• compact edition
• compatibility
• data
• database mirroring
• distributor
• errorr 21997
• failover
• FAQ
• high availability
• identity key
• kba
• linked
• maintenance
• merge
• message
• model
• monitor
• new feature
• oracle
• peer-to-peer
• performance
• permissions
• process
• replication
• roles
• schedule
• script
• service pack2
• setup
• snapshot
• sql server
• sqlagent
• subscriber
• subscriptions
• synchronization
• topology
• transactional
• tsql
• update
• version
• web

• 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... Posted Sep 20 2009, 10:54 AM by <P>SqlServer-QA.net</P> Filed under: sql server, replication, version, publisher, data, compatibility, subscriptions, new feature, peer-to-peer, model

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

  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... Posted Dec 15 2008, 05:37 AM by SqlServer-QA.net Filed under: sql server, database mirroring, replication, high availability, publisher, failover, monitor, maintenance, subscriptions, setup

• SQL Server Replication - resolving too many snapshots issues?

  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... Posted Apr 15 2008, 06:15 AM by SSQA.net Filed under: sqlagent, schedule, sql server, tsql, snapshot, replication, publisher, script

• SQL Server 2005 - specific roles for replication agents

  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... Posted Feb 22 2008, 02:10 PM by SSQA.net Filed under: sql server, replication, publisher, best practices, beginners, agent, distributor, permissions, subscriptions, roles

• Replication FAQ - how to know Distributor and Publisher with scripts

  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... Posted Feb 19 2008, 04:45 PM by SSQA.net Filed under: sql server, snapshot, replication, transactional, publisher, script, distributor, merge, schedule

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

  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... Posted Feb 07 2008, 09:41 AM by SSQA.net Filed under: sql server, performance, snapshot, replication, publisher, best practices, agent, subscriptions, FAQ, schedule

• Replication FAQ series - Which objects in the database are published?

  select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_published from sys.tables where is_published = 1 or is_merge_published = 1 or is_schema_published = 1 union select name as published_object, schema_id... Posted Dec 11 2007, 05:47 AM by SSQA.net Filed under: sql server, tsql, replication, transactional, publisher, distributor

• FIX: Error message when you synchronize a merge replication in a replication topology that contains two or more re-publishers in SQL Server 2005: "21997 Failed to allocate new identity range"

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you synchronize... Posted Oct 23 2007, 08:16 PM by SSQA.net Filed under: sql server, kba, replication, publisher, message, errorr 21997, topology, identity key

• FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX... Posted Sep 24 2007, 01:04 PM by SSQA.net Filed under: sql server, compact edition, kba, replication, publisher, subscriber, merge, synchronization, ce, web

• FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Changes in the publisher database are not replicated to the subscribers in a transactional... Posted Sep 12 2007, 12:46 PM by SSQA.net Filed under: sql server, database mirroring, 2005, kba, replication, transactional, publisher

• FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: When you start a merge agent, synchronization between the subscriber and the publisher... Posted Sep 11 2007, 04:36 PM by SSQA.net Filed under: sql server, process, kba, replication, publisher, subscriber, broker

• FIX: You experience a slow uploading process if conflicts occur when many merge agents upload changes to the publishers at the same time in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: You experience a slow uploading process if conflicts occur when many merge agents... Posted Sep 11 2007, 04:35 PM by SSQA.net Filed under: sql server, kba, replication, publisher, agent, merge

• How to reinitialize a merge subscription from publisher - SQL 2005 using TSQL script?

  Lately we have had a requirement to re-initialize handful of subscriptions to a publication within the merge replicaton setup. I was looking for a way out to achieve these operations programmatically using a TSQL script. I'm aware that using SP_REINITMERGEPULLSUBSCRIPTION... Posted Sep 11 2007, 04:03 AM by SSQA.net Filed under: sql server, update, replication, publisher, monitor, subscriptions, merge

• FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message"

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you try to create an Oracle... Posted Aug 19 2007, 04:40 PM by SSQA.net Filed under: sql server, kba, replication, service pack2, oracle, linked, publisher