How To Fix This Situation On Replication?[Urgent.]
Jun 26, 2004
Hi, all..
I by mistake Overwrites distribution DB.
Server1 and Server2 replicates each other.
Applications are using Server1, and Server2 is back up purpose.
When server1 fails application redirected SErver2, using same data since there is replication.
Server2 had distribution DB.
Now there is no distribution DB.. it's messed up...
I want to restore replication between Server1 and Server2.
I tried to make replication from Server1, I got errors..
I have a very urgent situation and to do with SQL Server 6.5, cannot start and the error message I got was: Initdata: Suballocation for buffer pages failed (838860 Bytes requested. Can anyone help me urgent matter.
I have a Transaction replication running between 2 SQl 2000 Servers. The distributor is on seperate machine.
Server1 is an online Db which is sending replicated trn to Server2 which is a reporting Server. Because of space issues, I have to remove about 100 Million Rows from Server1 Table without affectiing Server2 Table (Server 2 Retains those rows) Is there any Stored Proc available to disable the replication only during that time ?
Hi, I am configuring replication and i started using wizard . i opened publishing and distributor wizard and click on next it is saying that "Sql manager could not complete wizard because @@sername is null and use sp_add server name to set @@ servername. This is productionbox. Any body help me how to fix the problem and what is that meaning osf error. Thanks
Hi Guys, We are using transactional replication, I want to add a filter on the rows. Can Any one explain me how to add it. To do this we should stop replication and then add the filter ???.
Hi Guys, I am having around 1000 tables, in which around 700 tables are not having primary keys on the tables, The tables which are not having primary key, i want to set up an snap shot replication, Tables with primary keys with transactional replication. can i have both transational as well as snap shot set up on the same server????
I have setup the snap shot replication on one table.It says the initial snap shot not yet available.What does it mean?How to activate the replication? Thanks.
Hello there, I need some urgent help on the Replication .....SQL 6.5, sce 5a, windows NT4.0
A Publication has been installed between 2 server (SQL 6.5, sce pack 5a).
The task Repl_Subs_Distribution fails with the following message: "The last distributor job id and the last subscriber job id do not match. No jobs were available with a job id > 80"
1) with a Push Subscription, the error "no subscriber has been defined" came up, so I also did a pull subscritption for the remote server = could it be the cause of the job id not matching?
2) although I found a document on a "sp_Mskill_job" replication stored procedure, it is not present in my DB and I cannot use it. Is there a way to create it?
Thanks for your precious help. Best regards, Rachel
I was advised to Compair max job_id in MSsubscriber_status on distribution and MSlast_job_info on subscription and If not match, to modify the id in MSlast_job_info.
There is no distribution server in this Replication....any other idea or possibility??
I wanted information on Transactional Push replication between SQL Servers . I have one table on SQL Server 6.5 and there are certain text in the table with single quotes . When i replicate this table to SQL Server 7.0 the text appears in double quotes on SQL Server 7.0 .
Can anyone help regarding this problem ? Has it something to do with version problem .? Where can i get more information on this issue ?
Many thanks . An early response will be highly appreciated .
Thank you so much for your prompt response . Is it possible to change the settings of the Quoted Identifiers ? How can we do it in SQL Server 6.5 and SQL Server 7.0 ? Do you have any info. on the same . ?
I have a database replicated to another database in a remote server. We have a trigger in one of the tables in remote Database(replicated), which will fire as soon as there is an insert into this table. This trigger is maintaining the business logic. This trigger will insert the records into another table depending on what kind of information obtained from the new row(which was replicated). Problem is, since we are using replication ( it uses bcp internaly), the trigger is not firing. I some how wanted to add these new records to the other table (automated). Can you guys please advice me on how to implement this. I appreciate your help Thanks, Jeyam
I have been asked to take over the maintenance on dB servers that I have not originally 'set up'. The request came as a result of the database log files growing at such a rapid pace its taking up hard drive space. I ran sp_dboption and noticed that the log files are NOT set up to truncate on checkpoint. As in SQL 2000 I wanted to determine if the dB was set up in 'simple' or 'full' recovery mode. It appears they are set up in 'full' recovery mode (which we can modify, since this is not a transactional dB and we rarely if ever have to restore from the transaction log). Hence my question,
Is there anything I need to worry about (regarding replication)if I change the dboption to truncate on checkpoint and set dB in simple recovery mode?
And after I backup the transaction log and try to shrink it will that have any adverse affects? I feel like this is all I need to do but replication is new ground for me, any information regarding it would be greatly appreciated. Also, any advice on how to maintain the transaction logs would be helpful.
hi, I want to setup transactional replication(PULL) between 2 servers . can anyone guide me with the steps involved while performaing a Pull replication from server1 to server2. Any help appreciated.
I need some urgent help. I'm managing merge replication between 12 servers. Today I had to make some changes in the database design, so I removed replication, altered the tables in question (on all servers)and created a new publication. I choose the option that all subscribers have the data and the schema, but when I start the replication I get almost immediately an error "Invalid column name rowguidcol". But there is no column in my database with such a name. Further investigation brings up another message "xp_execresultset: unable to execute result set".
Can anyone please help me. The database should be ready by tomorrow.
Hi, Every one I have added new column in my Publication - Article Table , Same column I have added in my Subscriber Table , I am doing Transaction replication , but now its giving me error Insert Error - Column Name or Supplied Value doesn't Match, If any one has any idea please suggest me Thanks Nirmal
We are using Ms SQLSERVER 6.5 on NT 4.0 service pack 3 I have joined in as a new DBA and don't know much about MS-SQLSERVER & it's replication. What I have observed out here is that one of the databases was being replicated betnn Tokyo and Kawasaki and suddenly after 22nd Feb stop replicatiing without giving any errors. I have checked the max job_id in MSsubscriber_status on distribution database as well as max_job_id in MSlast_job_info on subscription db.They seem to match.I have also tried to drop and recreate the unique clustered index on the subscribing database.But nothing seems to work.
A Publication has been installed between 2 server (SQL 6.5, sce pack 5a).
The task Repl_Subs_Distribution fails with the following message: "The last distributor job id and the last subscriber job id do not match. No jobs were available with a job id > 80"
1) with a Push Subscription, the error "no subscriber has been defined" came up, so I also did a pull subscritption for the remote server = could it be the cause of the job id not matching?
2) although I found a document on a "sp_Mskill_job" replication stored procedure, it is not present in my DB and I cannot use it. Is there a way to create it?
Thanks for your precious help. Best regards, Rachel
By Accident One table got truncated on the subscriber which is one of the table in Published articles. Now all the Update inserts and delete are failing . and other tables are not being replicated either. what could be done to fix this . Publisher gets a lots of updates every hour how ever because of this problem all the tables are not getting any transactins replicated. Please help ASAP
I am trying to do transactional replication from 2000 to 2005 . But i am getting error" agent hasn't been registered .Run sql server setup program' while creating snapshot. It is production server. How do i make it work.I am doing pull subscription from 2005 server
I'm running merge replication with several databases. So far everything worked fine, but now I tried to insert some new records and I get the message:
Server: Msg 7139, Level 16, State 1, Line 1 Length of text, ntext, or image data (73728) to be replicated exceeds configured maximum 65536. The statement has been terminated.
Can anybody tell me how if I can change this max. value and how ? Thanks a lot Mike B.
Hi, I changed the sa password today on my subscriber databases, and now my transactional replication fails, as it cannot connect to the subscribers. I updated the publisher's linked server logins, but it still fails. Help please! Thanks, Jason
We have a sqlserver 6.5 and sqlserver 7.0 on separate machines. We cannot upgrade the 6.5 to 7.0 as of now since we have certain projects still running on that box. However,we would need to push and pull data across the servers.
Could we setup replication across the instances?although they are of different versions?
I am trying to do mearge replication with in our organisation. One server is located at server room(version 7.0) and it runs on NT server. Another server(desktop edition (version 7.0)) is at my desktop runs on NT Workstation. I am creating mearge replication from my machine making server room machine as Publisher and distributor and my desktop server as subscriber. But after creating replication when i view mearge agent job status it says that connection to my machine is failed. And because of this my replication is not working.
on both the servers "SQL Server Agent" service is running and i am also logging into both the servers with the same login with sa server role
I am getting following error in the "error details merge agent" dialog box catagory -------------source -------------------------Number Agent-------- "subscription server name" --------------20084 Data Source ---"subscription server name"-------------- 6
HI, We have one publisher and 100 subscribers. And Subscribers again act as re-publisher for 3-4 win CE (Handheld) based device subscribers. Now. We have already done the setup and it is working fine. Now due to some change in horizontal filters set in the publisher, we have change in publication. NOw whenever I make any change in publication, it says all subscribers will be marked for reinitialization and snapshot agent will run and new schema will be applied whenever next time merge agent runs. But whenever I run the merge agent, the snapshot agent fails saying invalid column ... . I am not able to revert the changes as the same error persists even after bringing the publication back to the original state. To add to the complexity, we have also used dynamic snapshots between publisher and suscribers. So, Can anyone please tell me how can I change the publication script without deleting the subscribers?Any pointers in this direction are really appreciated.
We have a publisher and 2 subsribers. The subscribers are spanning 2 transactions/sec. We have inplemented merge replication and it was scheduled to occur every 5 min. When we start the replication, the replications is going on without any problem for sometime(may be some hours), but after that it failes with the message, "the process could not deliver inserts at the publisher". We have SAN. When I searched for this error in google, it asked me to increase the queytimeout value in agent profile. So I increased it from 300 to 600, but in vain. If anybosy could help me in this, that would be great. Thanks, Preethi.
We have few branches with individual dbs are sitting in the branches itself. Periodically all the data need to be updated to a single HQ database. At the moment, all the tables's primary key are unique and each branch will have branch ID's in the transaction tables.
e.g. Branch1 data need to be updated to HQ db. However, HQ db records which are related to Branch 1 data only need to be updated back to Branch 1. other branch records should not goto Branch1.
Similaryly other branch records need to be updated/replicated back to HQ database. And only records related to the particular branch need to be updated from HQ (if any changes made)..
At the moment, i can do simple replication from one db to another db only... Can anyone guide/give suggestions on how to go about doing this?? If possible, please give steps involved...
I have two databases A & B which have a merge replication between them. Both are live data. I wanted to alter table in db A, so i deleted subscription and altered the table from db A. After that i rebuilt the replication between A & B with initialization but now my replication fails. Every time i get different error messages..recently i get message of 'Subscriber failed to initialize'. Could anyone suggest how to resolve this? Urgent please.
Some replication jobs failed and it shows 'data conversion failed' error MSSQL_REPL20037. Any idea on it ? I can't find the error in online book. THanks in advance!
With SQL Server 2005 SP1. We are working with transactional replication without problems. Now we try to create merge publications but we get this error at sync.: {call sp_MSsetconflicttable (N'BARArticulos', N'MSmerge_conflict_prueba_BARArticulos', N'ANTFOR-MLOPEZ', N'AntforHotel', N'prueba')}
The JOB show this error:
Mensaje 2007-02-06 12:30:47.127 {call sp_MSsetconflicttable (N'BARArticulos', N'MSmerge_conflict_prueba_BARArticulos', N'ANTFOR-MLOPEZ', N'AntforHotel', N'prueba')} 2007-02-06 12:30:47.174 Category:COMMAND Source: Error en el comando Number: 0 Message: {call sp_MSsetconflicttable (N'BARArticulos', N'MSmerge_conflict_prueba_BARArticulos', N'ANTFOR-MLOPEZ', N'AntforHotel', N'prueba')} 2007-02-06 12:30:47.174 Category:SQLSERVER Source: ANTFOR-MLOPEZ Number: 102 Message: Sintaxis incorrecta cerca de 'Articulo'. 2007-02-06 12:30:47.174 Category:NULL Source: Proveedor de rÚplica de mezcla Number: -2147201001 Message: El proceso de mezcla no pudo entregar la instantßnea al suscriptor. Si se utiliza sincronizaci¾n Web, es posible que el proceso de mezcla no haya podido crear el archivo de mensaje o escribir en Úl. Para solucionar el problema, reinicie la sincronizaci¾n con registro de historial detallado y especifique un archivo de salida para escribir en Úl.
