Browse by Tags

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

Published 26 May 8 4:1 AM | SSQA.net

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

Filed under: sql server, replication, BOL, features, support, filestream

SQL Server Replication - resolving too many snapshots issues?

Published 15 April 8 6:15 AM | SSQA.net

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

Filed under: sql server, replication, snapshot, sqlagent, script, publisher, tsql, schedule

SQL Server 2005 - specific roles for replication agents

Published 22 February 8 2:10 PM | SSQA.net

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

Filed under: sql server, replication, permissions, best practices, roles, agent, publisher, beginners, distributor, subscriptions

Replication FAQ - how to know Distributor and Publisher with scripts

Published 19 February 8 4:45 PM | SSQA.net

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

Filed under: sql server, replication, snapshot, script, merge, publisher, transactional, distributor, schedule

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

Published 13 February 8 5:2 AM | SSQA.net

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

Filed under: sql server, tools, upgrade, replication, error, error log, timeout, servers

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

Published 7 February 8 9:41 AM | SSQA.net

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

Filed under: sql server, performance, replication, snapshot, best practices, agent, publisher, subscriptions, FAQ, schedule

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

Published 30 January 8 12:23 PM | SSQA.net

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

Filed under: sql server, microsoft, data, integration, security, download, replication, reporting services, magazine, windows it pro

Transactional Replication Snapshot Issues - useful resources to resolve

Published 16 January 8 1:8 AM | SSQA.net

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

Filed under: sql server, microsoft, security, replication, merge, transactional, tips, setup, links

How to perform Replication within different domains?

Published 18 December 7 12:15 PM | SSQA.net

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

Filed under: sql server, security, replication, sa, transactional, impersonate, internet, different, domains

How to find subscriber is not getting upto date data?

Published 14 December 7 7:18 PM | SSQA.net

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

Filed under: sql server, data, replication, error, subscriptions

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

Published 12 December 7 4:4 PM | SSQA.net

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

Filed under: sql server, microsoft, replication, snapshot, best practices, merge, transactional, beginners, types

Replication FAQ series - Which columns are published in snapshot or transactional or merge publications in this database?

Published 11 December 7 6:48 PM | SSQA.net

Here is script you can find which columns are published in the replication that is using either snapshot or transactional or merge publications. --For snapshot or transactional publications select object_name(object_id) as tran_published_table, name as...

Filed under: sql server, replication, snapshot, merge, transactional, tsql, tables, columns, FAQ

MSDN labs - Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005

Published 11 December 7 10:11 AM | SSQA.net

Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product . Similar...

Filed under: sql server, msdn, technet, replication, best practices, virtual labs, merge, compact edition, mobile, developement

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

Published 11 December 7 5:47 AM | SSQA.net

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

Filed under: sql server, replication, publisher, transactional, tsql, distributor

Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: "HRESULT 0x80004005 (0)"

Published 21 November 7 4:25 PM | SSQA.net

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 Error message when you try to replicate...

Filed under: sql server, replication, error, kba, hresult, mobile edition

FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriber

Published 16 November 7 3:5 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: An empty string is replicated as...

Filed under: sql server, replication, kba, table, 2005, compact edition, synchronization

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"

Published 23 October 7 8:16 PM | SSQA.net

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

Filed under: sql server, replication, kba, publisher, message, identity key, topology, errorr 21997

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

Published 24 September 7 1:4 PM | SSQA.net

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

Filed under: sql server, web, replication, kba, merge, subscriber, publisher, compact edition, synchronization, ce

FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005

Published 24 September 7 1:2 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX...

Filed under: application, sql server, performance, replication, kba, 2005, memory leak, terminate, activex, initialize

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

Published 12 September 7 12:46 PM | SSQA.net

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

Filed under: sql server, replication, kba, database mirroring, publisher, transactional, 2005