.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Asad Ali
Post New Web Links

Replication issue

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

Hi,

      My distibution database data file is growing nearly 20gb my disk space is low.what is the solution.


Thank's&Regards Siva


View Complete Post


More Related Resource Links

merge replication system tables fragmentation issue

  
I have Merge replication going on in my environment. The problem is that system tables like MSmerge_content, MS merge _tombstone and MSmerge_genhistory are getting fragmented. We are rebuilding indexes time to time daily. But we want some good fix. Just send some good idea guys?

Issue with transactional replication on SQL 2005 SP3 using row filters with bit columns

  
We recently upgraded from SQL 2000 to SQL 2005 SP3 and I am noticing something that I think is a bug with replication from a publication that has an article in it with row filters.  It seems to be that if the row filter has columns that are bit datatype and that column is updated on the publisher to cause the row filter to exclude it, it is not removed from the subscriber.  If you update a column that is part of the row filter that is not a bit datatype it works as expected.  I can reproduce this in a test environment with a small base table.  In production this is resulting in an occasional 20598 error "The row was not found at the Subscriber when applying the replicated command". Is anyone aware of a hotfix that addresses this? I can think of a few work arounds but the table is rather large and I really would like to avoid having to pull replication, re-snap or changing datatypes on the base table etc. Any suggestions are greatly appreciated.  Thanks!

Issue with sharepoint site replication?

  
Hi all, I have a requirement where in i need to replicate the business intelligence report to N no of subistes i am able to create reports to the site and also able to replicate to another site. But the problem here is the webparts that are getting created in the new site refers to the same old location and it is giving me exception that the filter is no more valid one. Is there any way i need to change the location of the newly created webpart location. Waiting for your reply.  

Replication issue - Log Reader stuck on Initializing urgent!!

  

Log Reader stuck on Initializing, I have SQL server 2008, and the transactions are not getting replicated to subscriber. Any ideas!!


sqldev

Replication issue from Oracle to SQL Server

  

We have SQL Server 2008 64bit on windows 2008 and Oracle 10G. Some data is not getting replicated from Oracle to SQL Server, the distribution agent job runs fine and I do'nt see any errors. To make sure I also restarted log reader agent, reinitialized subscriptions etc. but even then some data is still missing. The distribution agent job is schduled to run every 15 minutes. It is transactional replication.

Any ideas. Thanks!


sqldev

SQL 2005 Merge Replication Issue

  

Ihave merge replication set up between two sites. Everything worked fine up until the subscriber wanted to update the publisher. I get the following error:

The merge process is retrying a failed operation made to article 'X' - Reason: 'The Merge Agent was unable to synchronize the row due to one or more unanticipated errors in the batch of changes. When troubleshooting, increase the -OutputVerboseLevel setting, restart the agent, and check for and resolve any errors generated by the database engine. '.



SQL Server 2005 Replication - Replicated Databse Performance Issue

  

Hello,

 

I am struggling to work out a very frustrating replication issue and wondered if anyone could help me.

Here is my situation.

 

I have a virtual machine with 16gb RAM and 4 quad core 3Ghz processors and 250gb disk. This has Windows Server 2008 64 bit installed.

The machine has a SQL Server 2005 64 bit instance installed with SP3.

I have setup a publication on this SQL Server called pub1 , this publication publishes all tables/sp's /views and UDF's . I have set the article properties for the published tables as below.

- Copy Check Constraints = True

- Copy Clustered Index = True

- Copy Non Clustered Index = True

- Copy Default Value Spec = True

- Copy Collation = True

- Copy Insert, Update and Delete = True

- Copy unique key contraints = True

- Copy XML Indexes = True

Every other setting is set to false.

I have created a subscription to pub1 within the same SQL Server instance. The database has replicated everything I require without an issue.

If I run a query against the databse that I have published, it returns the query in less than 10 secs. If I run the same query against the subscription DB then this query takes over 30 mins to return.

I thought this was an issue with the indexes not replicating. From what I have selecte

Transactional push replication in SS2008r2 Timeout issue

  
The problem: Set up transactional (push only) replication from SS2008r2 to remote SS2008r2

The issue: Replication manages to send the table structure before going into an unending cycle of trying to send the data and receiving Sql Native Client Semaphore timeouts - Try again later msgs. From what I've read, this indicates some sort of network issue.

Side observation - setting up and initializing a snapshot replication of a larger table to the remote server works like a charm.

Question: (1) Why does the straight snapshot work and not the initial snapshot for the transactional subscription. (2) Where, how to troubleshoot this issue ( i need some guidance here so point me in the right direction). I'm ready to enter into dialog. Thanks in advance for your help.

Koko

joekoko

Transactional push replication in SS2008r2 Timeout issue

  
The problem: Set up transactional (push only) replication from SS2008r2 to remote SS2008r2

The issue: Replication manages to send the table structure before going into an unending cycle of trying to send the data and receiving Sql Native Client Semaphore timeouts - Try again later msgs. From what I've read, this indicates some sort of network issue.

Side observation - setting up and initializing a snapshot replication of a larger table to the remote server works like a charm.

Question: (1) Why does the straight snapshot work and not the initial snapshot for the transactional subscription. (2) Where, how to troubleshoot this issue ( i need some guidance here so point me in the right direction). I'm ready to enter into dialog. Thanks in advance for your help.

Koko

joekoko

Transactional Replication issue Between SQL Server 28 R2 and Denali (SQL2011)

  

Hi All,

OS :Windows 7

SQL Server Instance : SQL Server 2008 R2 (Publisher)

Distributor : On SQL Server 2008R2

SQL Serer Instance : SQL Server 2011 Denali (Subscriber) Pull Subscriber.

Replication Topology :  Transactional Replication

I have Installed SQL Server 2008 R2 and SQL Server 2011 CTP on the same machine. Setup Replication between SQL Server 2008 R2 and SQL Server 2011 using Transactional Replication Topology.

I have added one table as artical with default settings , the table has one int and 4 varchar datatype columns having rows=26004606.

While distributor agent deploys the snapshot on the subscriber , it failed with the below error :

SQL Server encountered: '23(Data error (cyclic redundancy check).)' resulting from an attempt to read the following: sort run page (1:35472), in file 'D:\Program Files\Microsoft SQL Server\MSSQL11.DENALI_2011\MSSQL\DATA\tempdb.mdf', in database with ID 2.

Issue with SQL 2008 replication logreader errors The process could not execute 'sp_repldone/sp_repl

  

I noticed the log reader agent with the following errors on a production server.

 

The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The specified LSN {00037507:00003d5a:0005} for repldone log scan occurs before the current start of replication in the log {00037690:000015b5:0004}.
The process could not set the last distributed transaction.
The specified LSN {00037507:00003d5a:0005} for repldone log scan occurs before the current start of replication in the log {00037690:000015b5:0004}.
The process could not set the last distributed transaction.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The specified LSN {00037507:00003d5a:0005} for repldone log scan occurs before the current start of replication in the log {00037690:000015b5:0004}.
I then tried to check the Msrepl_transactions table for any information. This was blank, before hand I had noticed a high number of deadlocking going on with the distribution history tables on thesame publisher/distributor.

SQLCF 3.5 SP2 Replication Issue: An instance of the SQL Server Reconciler error object cannot be cre

  
Hi, we have a desktop application synchronizing with our SQL server using merge replication via IIS6.

Previously we used SQL2005 Ent database server, SQLCF 3.5SP1 tools and runtime library were installed on IIS machine, the desktop application was compiled with SQLCF 3.5 SP1 runtime as well.

Last week we upgraded our server to SQL 2008 R2, the application has been broken since then.

We tried to upgrade to SQLCF 3.5 SP2 tools and runtime on IIS ==> didn't help
We tried to install SQLCF 3.5 SP2 on the desktop where the application running (but left the application unchanged) ==> didn't help

Could anybody here help me with this? Do I need to re-compile my application?

Here are some debug information:
SQLCESALOG.TXT: Thread=1284 RSCB=1 Command=SYNC Hr=00000000 Failed to use 10.0 error components. Exiting... 0

Diagnostics:
Impersonation and Access Tests Action Status ErrorCode
Impersonate User SUCCESS 0x0
ReadWriteDeleteMessageFile SUCCESS 0x0

SQL Server Compact Modules Test Module Status ErrorCode Version
sqlcerp35.dll SUCCESS 0x0 3.5.8080.0
sqlcesa35.dll SUCCESS 0x0 3.5.8080.0

Reconciler Test Reconciler Status ErrorCode
10.0 Database Reconciler SUCCESS 0x0
9.0 Database Reconciler SUCCESS 0x0


Any help would be appreci

SQL EXPRESS 2008 replication issue with sync media center on windows 7

  

Dear all,

I am not able to configure the system in order to make it solve merge conflicts interactively (that is with the help of the user).

The configuration is the following one:

PC-A: sql server 2008. With one the DB "myDB" published for replication.

PC-B: sql server 2008 r2 express. With two replicas of "myDB" on the same instance of sql express: "myDB1Replica" and "myDB2Replica"

The two replicas simulate two users that change the content of the same record so that I can test how the system behaves in case of conflicts.

Everything runs smoothly if "Resolve conflicts automatically" is set... but I get this error message when "Resolve conflicts interactively (only applies to articles that support interactive resolution)" is selected.

Error: The merge process failed to get correct information about the Interactive Resolver component from the registry. Verify that the registry exists and that the path is correct.

Of course this has been enabled on the article (from PC-A on sql server) and on the subscription (from both PC-B sql express and syncro center) as well.

 

I have been searching everywhere and found nothing! Any help would be really appreciated! I really need to run the interactive conflict resolution

Issue while adding article to existing subscription(Transactional Replication)

  

We are haing issues while adding article on existing subscription.

The replication is setup with Initialize from backup=true.

Below is the command I tired to use aftet transfering the rows thru export import wizard but the table on the subscriber isnt refreshing.

exec sp_addarticle @publication = N'marcus8rpl' , @article = N'appnames' , @source_owner = N'dbo' , @source_object = N'appnames' , @type = N'logbased' , @description = null , @creation_script = null , @pre_creation_cmd = N'NONE' , @identityrangemanagementoption = N'manual' , @destination_table = N'appnames' , @destination_owner = N'dbo' , @vertical_partition = N'false' , @ins_cmd = N'CALL sp_MSins_dboappnames' , @del_cmd = N'CALL sp_MSdel_dboappnames' , @upd_cmd = N'CALL sp_MSupd_dboappnames'


Issue while Adding article in existing publication Transactional Replication.

  

We are facing difficulties adding article to an existing publication.The replication was setup by restoring the backup on subscriber  from publisher and changed the setting Intilialize from Backup =True

Used the following steps but it almost bought down the system.

EXEC

sp_addarticle

 

@publication = N'marcus8rpl',


Transactional Replication ISSUE - 487 tables need to be replicated

  

Hi All!

I have configured transactional replication on 7 databases from an sql server 2005 to another sql server 2005.

One of them has 487 tables and when I check "Replication Monitor" it shows that everything ok, but database above , that shows the message "Performance Critical".

My question is : The tables have been replicated or not ? How can I check this ? It´s not possible check table per table. Anyone suggests any other way to check if tables and their data have been replicated.

Thanks in advance ,

RBretas.

 


Insert into merge replication database issue...

  

I've been fighting with merge replication for the past few days over the same hurdle and I can't seem to figure this one out.  I create the publication that publishes 36 articles (28 of which are download only).  After creating the publication, I can replicate perfectly normal as expected.  When replicating, I pass in a project number through the host_name() variable and filter the data based on that value and all works great.  I've replicated about 10 different projects, modified data, and merged the changes back without issue.

Where I'm running into an issue is when I add a new project to the mix.  I have an SSIS project that takes data and puts the data into a staging area.  From there, I have an ETL that pulls the data from the staging area and inserts it into the the database that is set up with merge replication.  Being that these new records will need to be replicated in the future, I do a simple insert into, select from so that the replication triggers are fired and these rows are tracked.

After the data load (~150,000 rows in total among 5 tables), I go to replicate this new project however it never gets past the step

"Retrieving subscription information."

It eventually times out and never transfers the data.  When I go back and try to rep

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend