When I am trying to Shrink CRM Database log in SQL Server the transaction log says that users are connected to the Database. How to clear the Transaction log when users are connected to the Database.If not how to clear the Log when the Databases are in replication mode. Ram ...more >>

In a replication topology with multiple subscribers, how do you bring the system back up quickly if the main publisher suffers a catastrophic failure and must be replaced by a different server? Assume that the subscribers continue to process transactions while the publisher is offline. Also as...more >>

Hello, Can someone tell me which is better to use pull subscription or push? Thanks -Nilay...more >>

hi everyone, I have managed to do a merge replication between a sql server 2000 database and a microsoft access xp on a local computer using Jet OLE DB setting at sql entripise setting. After sync, the replicated table at the Access cannot be added to the database relationship or added i...more >>

I'm in the process of designing a SQL 2000 design that will use log shipping to maintain a backup server in case the primary SQL 2000 goes down. I understand the implications of using log shipping vs replication or clustering, but one of the specs of the system is to have the backup server be one t...more >>

I have 4 boxes for Development/Production running SQL 2K w/SP3 Replication. My Development setup is same as Production (1 Publisher/1 Distributor). If I look at my Merge Agent properties on my Development Distributor I can see the MetadataRetentionCleanup property in the Default Merge Agent pro...more >>

Hi there; I have a very strange problem. We are running merge replication for a while and it just stopped working overnight. I am no longer able to create a snapshot.It stops with the message: An exception occured in the Snapshot subsystem. I browsed the newsgroup and someone suggested to run...more >>

Hi All I have a problem: When I created merge replication, system tables , named like aonflict%, conflict%, conflict%... (% is a string) , also were created. Now I disable replication and I want drop these tables. I can not drop them. How can I drop these tables Many thanks for help Nguyen ...more >>

Hi How to change the data type of a column without dropping the merge replictaion Thanks San...more >>

If i want to replicate all schema(tables,stored procs,views,indexed views and functions) and data obviously , do i need to make one publication or seperate for views and indexed views and functions as views need to depend on tables being created and indexed views on views and functions on tables ...more >>

I have defined a merge replication scenario since both subscriber and publisher need to update data. I have a table that has a numeric field that, if there is a conflict, I want to add up. I have defined this article to use "Additive Conflict Resolver", but somehow it does not work as I expe...more >>

what must a database be set to in order to participate in replication? here is my situation... i have a database that is marked for publication. I want to shrink the database and the data file. the recovery model for this database is Full. am i able shrink the database (that is mark...more >>

I established a transactional replication. I want to add not for replication attribute to the identity column using Query analyzer. Surely, By Using Enterprise Manager is easy. but I want to know the method using SQL. I tried to write sql query as below.. ------------------------ create tab...more >>

We have exactly the same problem as it is described on the Microsoft Knowledge Base Article - 814916 page (http://support.microsoft.com/default.aspx?scid=kb;[LN];Q814916). I'd like to know, why we have to contact MPSS and pay to get this fix - is this common policy for solving bugs or the reason...more >>

I am running Win 2k & SQL 2k. I am using transactional as well as merge replication and one of my SQL Servers is showing an error (the red circle with the white X in the center) on the Replication Monitor. When I expand the Replication Monitor an error is shown on the publisher folder as...more >>

Hello All, I try to setup replication for disaster recovery project and I ran into this problem. All my primary keys in my subscriber database are gone after the snapshot agent ran. Does anyone know why? Before I setup replication the subscriber database has primary keys. Please let me kn...more >>

I have replication installed on a SQL Server 7.0. The msdb database is suspect and now replication is failing. Other than uninstalling/reinstalling SQL, what is the fastest way to recover the msdb database? I tried running sp_resetstatus 'msdb' in Query Analyzer but I get the following me...more >>

I have configured transactional replication between 2 SQL Server 2000 machines. I have created articles which contains stored procedures also. But the stored procedures are displayed with a "Lock" image and i could not select specific things When all the stored procedures are selected, while rep...more >>

I have trans replication between 2 sql 2000 servers. A one way push basically and continuous Its not replicating for some reason. I see the log reader agent applying changes but the distribution agent does not seem to be doing anything. It is running and the changes are not being shown on the ...more >>

My department is thinking of implementing Log Shipping for a database. We have a concern that, due to the nature of replication via log files, some transactions may not execute properly on the secondary server and when this occurs we will have essentially non-matching databases. Is this concern...more >>

HI, I have merge replication with pull subscription. I=20 have two tables with master-detail relationship. All the data is sent to the publisher find, except this=20 two tables. In the subscriber the data is fine inserted=20 (first insert master table and second detail table) but=20 when it t...more >>

Hi, one of my subscribers remote location faced a problem of sysmergepublications table corruption . Please suggest a way to solve it . Already tried dbcc checktable Regards Ajay ...more >>

When i am setting up replication it is giving Error 14234, you can not create distributor database on this server.This is in KB 310639. If i want to change the stored procedure, sp_add_jobstep, sp_add_jobstep_internal ( I want to change the @Server nvarchar(30) to what i want). What is the procedu...more >>

Can anyone direct me to documentation on the stored procedures that sp_createmergearticle creates? I've been trying to get a better understanding of what goes on in the background during the various merge replication processes The created stored procedures start with sp_upd_, sp_ins_, sp_del_...more >>

Hi I am new to replication , I have got merge replication installed one of the remote server has crashed .. What would be the best way to synchronize the crashed db with the db which is getting published Regards Ajay ...more >>

Our app. works fine until we push out a subscription. At this point we can't add a fingerprint to a new person in the database. when we turn off replication(which works fine) we can once again add new people with their fingerprint to our database....more >>

I get this error when trying to add a publication. It looks like when the initial snapshot agent is created. Any ideas? ...more >>

We have one of our subscribers sending us logs from their firewall showing netbios (139) request coming from our IP address. We are doing transactional replication to them. Does replication use netbios? If so, other then vpn, is their a way to fix this just for this one subscriber? tia...more >>

I am relatively new to SQL 2000 server administration and database design/programming. 1) If I define a relationship bewteen 2 tables and enforce referential integrity (cascade deletes and updates) will this change be replicated? I have snapshot replication setup for a set of tables includin...more >>

I am trying to find the best way to monitor the merge agent status for a pull subscription on a continously updating subscriber at the subscriber. Basically, I am writting an application that will watch whats happening with the merge agent and if replication problems occur for a certain length o...more >>

I am tring to remove replication from a sql 7.0 server in anticipation of migrating it to a sql 2000 server. I am trying to disable replication on it and have run into one problem. I have one published item that wont delete. According to E.Manager there are no subscribers. but it wont go a...more >>

Hello, I am currently using SQL Server 2000 merge replication with th publisher and suscriber databases on seperate servers. When one of th servers is taken offline then the replication stops. I have t manually restart the replication through enterprise manager once bot databases are back ...more >>

Hi all, is there anyone in area that have experience about snapshot replicate from server ---> client? My trouble is that in the client (subscripter) i don't succeed to start the sqlserver-agent. log return this error: [LOG] Exception 5 caught at line 191 of file ..\src\refreshr.c. SQ...more >>

SQL Server 7.0 SP3 running on Win2K SP3. Network hiccupped and now logreader in database servicing three publications will not run. gets error message "another log reader is rep[licating the database" with error number 18752. ALso has error message "The process could not set the last di...more >>

Can I restore the latest copy the database(40gig) to the subscriber server then start replication to avoid the initial run of the snapshot. Is there any way to avoid the initial run of the snapshot? ...more >>

during log shipping while nothing is happening on the database, is it normal for the log to increase from 5mb to 2-3 gb during replication?...more >>

Hi, Tonight, we are having consultants doing some work on our SQL 2000 server production database (publication) which is running transactional replication to a database on another server. They want to put the publication database into "single user" mode to make their changes. The repl...more >>

Being a SQL 2000 newbie I would like to know how Merge replication works...especially how Primary Key fields are handled eg PK autonumbered on Machine_1 is 1 and next PK autonumber is 2 However if at same time Machine_2 wants to add row then that PK autonumber is 2 too...what happens when ...more >>

Hi, if i try to start setting up merge replication with the "Configure Publishing and Distribution Wizard" of the enterprise manager, and configure my local server to be its own distributor, I receive an information message box that the local sql server agent is using the local system a...more >>

Hi I've following are the questions related to MS SQL. 1) We configured the log shipping between 2 sql server instances. This configuration is done using "Database Maintenance Planner".Log shipping and applying happening successfully.In the event of recovery failed at standby server h...more >>

H I'm currently generating the transaction logs using log shipping methodology. Would like to understand how I can manually apply these transaction logs on the standby server? Is there procedure or commandline interfce to do that same. My goal is it apply these logs on the standby server at my ...more >>

We are thinking of implementing this. Publisher in our datacenter, 3 subscribers are international. Merge replication topology. Any things , gotchas i have to be aware of ?...more >>

I have had SQL7 replication up an running for about a year now with few problems. I think I may have make a huge mistake this morning though. I have several stored procedures replicated that do a massive amount of updates to data each night (instead of replicating the changes). This morning I mad...more >>

I have a Windows 2000 Server SP4 and SQL Server 2000 SP3 (SERVER1), both with the last updates available from windowsupdate. This server is located at the central office, we have a low speed conection with another office, and I am configuring a local server for them. This server is a Windows 200...more >>

Running Win 2000 & SQL 2000 I had a transactional publication that had a PK that was an identity field. I needed to extend my PK. I dropped the publication, extended my PK, deleted the data off the subscriber and recreated the publication and subscription. The subscription fails, retur...more >>

Hi there, I adjusted the retry attempts of the distribution agent (under the list of steps, this is step 2, "run agent"). The default behavior is 10 retry attempts spaced one minute apart; I changed this to 7220 attempts at 2 minutes apart (2 weeks). I did this because I wanted replication to ...more >>

Running Win 2000 & SQL 2000 I had a publication that had a PK that was an identity field. I needed to extend my PK. I dropped the publication, extended my PK, deleted the data off the subscriber and recreated the publication and subscription. The subscription fails, returning the err...more >>

I am going to implement log shipping and it seems to require SQL 2000 Server Enterprise Edition.....does anyone know whether it requires Windows 2000 Advanced Server, or can it be done on a regular Windows 2000 server? Thank you....more >>

Hello all - I have a snap shot replication publisher/subcriber running SQL Server 2000 and Windows 2000. I have serveral triggers running on the subscribers which writes to a table when a replication data change has occured. The part of trigger like: If Update(Column) Begin inse...more >>

I'm getting this error on the Distribution Agent. "Cannot use a CONTAINS or FREETEXT predicate on table 'saa_catalogue..t_Catalog' because it is not full-text indexed." We have Full-text catalog setup on both the Publisher and Subscriber. I tried to run the agent by deleting first the full-t...more >>

Is it true for pull subscriptions, that the current login must be a member of the Administrators group on the subscribing machine in order to successfully synchronize with the Publisher/Distributor? This seem wrong, but so far, it's the only way I can make it work. Details: I'm testing r...more >>

We are running SQL Server 2000 SP3 on a publisher, remote distributor and subscriber, and we experienced a problem with "Violation of Primary Key" on multiple articles during distribution. The distributor is trying to add the record twice. I found a knowledge base article http://support.microsoft.co...more >>

Hi there, I am going to setup a simple replication having publisher and distributor in Domain A and Subscribers in Domain B subscriber server uses SQL server authentification, SQL agents of both servers are using a special created user. it works fine as far as the snapshot folder is set t...more >>