I just recovered a broken server with Windows 2000 server and Sql Server 2000. I had to format the hard disk and I recovered the database files (.MDF and ..LDF) from console, because the Windows installation was lost. There was a replication (the server was a subscriber) so now, after I attache...more >>

Hi everyone, I'm currently running sql2k sp3 on win2k3. It's a clustered server and running merge replication with another clustered server offsite. Right now our snapshots are taking too long (almost 8 hrs, database is about 180 GB). The snapshot folder is on a local drive so it should ...more >>

I am trying to get my log files to reduce in size, but when I run DBCC LOGINFO (MPlus) I get 491 rows with status =2 so when I go to shrink the logfile after a backup (BACKUP LOG MPlus WITH TRUNCATE_ONLY) I get "Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as di...more >>

After completing my replication, my both publisher as well as subscriber are getting updates properly.But the user at the Publisher end are facing problem in Logning into the software(Means SQL response has gone slow) Help Neede Thnks ASif...more >>

Hi, I am trying to create a pull subscription on a server. By the end of New Pull subscription Wize, an error message shows '15004: Name cannot be NULL'. Does any body know why and how can resolve this. Thanks in advance, Ping...more >>

Hi Guys in logshipping to fail over to stand by server do i have to do any role change as far as i know i have to run following script at the stand by server. am i right? RESTORE DATABASE database_name WITH RECOVERY EXEC SP_DBOPTION 'database_name', 'read only', 'false' ...more >>

I have two databases that replicate with merge replication. A couple of days, the replication process failed while trying to do a re-initialization (with upload changes to publisher option enabled) and it seemed that some of the records in the subscriber were missing. So I did a restore of the subsc...more >>

Hi NG I use -SkipErrors XXXX Parameter in TransactReplication (msql2k) If an error XXXX occurs, the error skipped and the replication process continued. That's fine. In the History-Table is a hint of the failure. But where I can find the SQL Statement, which the error raised? thanks T...more >>

My situation: I have a DB hosted by a 3rd party ISP. I want to replicate that DB locally with in my office on our local server, mainly for backup purposes. I then want to replicate that backup DB to a development DB for testing purposes. Basically I'll have a LIVE DB hosted at the ISP. A ...more >>

Hi, everybody ! I've tried to use merge replication but the replication agent failed = with the following: The process could not deliver the snapshot to the Subscriber. (Source: = Merge Replication Provider (Agent); Error number: -2147201001)=20 The process could not bulk copy into table ...more >>

How can i go about setting up a simple replication between 2 Databases on the same server? The company want to keep both tables insync especially when it comes to the identity columns. Thank you, Gordon...more >>

My @@servername is null, and I had executed the stored procedure sp_addserver. Without @@servername, I cannot config the replication. Any help? ...more >>

Does anyone know of a reasource that will describe exactly what happens during merge replication. I particular, I would like to know what is happening when the merge agent history says "Downloaded xxx data changes". Where is it downloading it to?...more >>

Guys I have Merge Replication on SQL SERVER 2000....more >>

Hi NG In transactional replication I found a different length of the following varbinary(16) fields: select xact_seqno from distribution..msrepl_transactions go RESULT: 0x000000110000171B0001 but select transaction_timestamp from MSreplication_subscriptions RESULT: 0x0000...more >>

Hi I have a transaction replication b/w two servers. In the publisher's subscription list status,it displays deactivated The Replication is stopped because of this, i am not able to change the status. What to do ? Please let me know....more >>

Does MSFT provide access to debug libraries to help decipher error and system messages Are there any distance restrictions on replication In a merge (or master to master) scenario can you set up one instance as the primary and one as a secondary as far as conflict resolution Performance issues/s...more >>

Hi, I have an SQL 2k database on a dedicated server in another city which I need to replicate to a backup server in the office. The replication aspect is not a problem except that the database tables are changed from time to time, sometimes a new column or changing an existing column. Whilst w...more >>

Hello I have a SQL 2000 replication where the publisher has dropped the agent (expired) because of lack of connectivity. The agent still appears on the subscription server. I would like to get the subscription back on the publisher. Would all I need to do is run sp_dropmergesubscripti...more >>

I've got a SQL 2000 database using merge replication over the internet, to stand-alone PCs using MSDE. I have an installation package that works fine for Windows 2000 and XP, installing the snapshot and synchronizing through code with a pull subscription. I'm using SQL authentication, and setting t...more >>

Hi, What happens when I add a new column to a replicated table using the SP 'sp_repladdcolumn' when the subscriber initiates the synchronization. Do the changes made on the subscription database get replication to the publishing database first before the new schema change is migrated to ...more >>

Hi, we are using merge replication for our remote locations on sql2000 sp3. I have created a snapshot and trying to initialize the snapshot. the replication went for over 2 hours and after initializing the snapshot file and when it was going through the uploads and downloads. now it shows ...more >>

I have a database which requires merge replication which can be horizontally partitioned into 25 branches. Would this create 25 distribution databases and is there a high impact on the performance on updating these databases? Or is the best solution to use is dynamic horizontal parti...more >>

I've managed to do the add linkedserver stuff and pull up of some active directory information. I even matched up some data but could never insert anything into the AD Meta fields. I used this article, http://msluder.dk/Resources/ADSI%20SDK%205%20HTML/dq.htm ,which never promised insert capabi...more >>

Hello I have two server both running SQL 7 SP4 on W2K server SP 4. One SQL server is both the distributor and publishwer and the other one is the subscriber. I published one database on the server (replication type = shapshot) and there were no problems when running the jobs that this task creates...more >>

Why am I getting this error ? The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. My replication is set to expire only after 336 hours. It failed last Friday at 10:00 a.m. and after 3 days when I am refreshing,...more >>

the ms article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/rep lmon_88c2.asp intimates that I can get a red x on replication monitor, but may not be able to see the agent that is causing the error. I have run all my cleanup agents, and I have completely removed and d...more >>

Hi, i have a publisher running sql server 2000 sp3. I have configured a merge replication with two push subscriptions. I need to delete the subscriptions and the publication but when i try to do it, i get this error: Error 207: invalid column name 'enabled_for_syncmgr' I'll really apprec...more >>

Hi - I'm trying to set up merge replication between a SQL2K database on the desktop and a SQLCE database on the device. A problem arises because the SQLCE database already (before replication is implemented) has data that I don't want to lose. If I just set up merge replication between the t...more >>

I have a publisher that publishes a subset of master data ( transactional ). The subscriber then publishes the same tables to dumb, live servers. Transactional again. The master server ( the first one in the chain) is the distributor. Replication is initiated via the Replication ActiveX objects ...more >>

Hi Guys, I am using sql server 2000 on active/passive cluster with transactional replication. now i want to implement logshipping for this publisher to copy and restore the log files to the stand by server every 1 minute. the servers are connected by a LAN. I HAVE FOLLOWING QUESTION 1)WI...more >>

We have installed SQL Server 2000 on a new server running Windows 2003 This server is the distirbution Server. It also contains a one database. THis database subscibes to data from other servers and publishes data to other servers One of the publications is an updateable subscription. Ths subscr...more >>

In merge replication, if I select to re-initialize the subscriber. Is the database available to the end users while the snapshot is being applied?...more >>

Hi I have merge replication. One client is already subscribed. I need to add another client to the publication The database is pretty big, so I don't want to send the whole db over the internet. I want to back it up and restore it, then establish the subscription. Are the steps a) bac...more >>

does anyone have an idea of what generally could be wrong with a pull merge subscription when it errors out with the following: sql server The merge process could not retrieve column information for table "tablename" Also, could you tell me where I can get more details of errors (i.e. where th...more >>