While playing with log shipping it appears that the restore is timing out, without errors. The shipper is successfully backing up to disk, xcopying the backup to the receiver, calling the restore SP on the receiver. The restore runs for exactly 10 minutes and 1 second then ends with a success. Any i...more >>

One quick question..... If I DTS to import some data, does is trigger replication????? I imported a text file using DTS and I don't see the data in my subscriber. Thank you in advance Marlene ...more >>

I have a situation where I need about 50 client machines that are collecting data to synchronize with a network server on our local 100 Mbps LAN. Am running SQL Server Enterprise 2000 on the back end. Have experimented with using MSDE on the client machines and using merge replication with a ...more >>

my company is running SQL Server 2000 ENT for its Axapta implementation. we would like to create a reporting server to off-load some of the resource intensive reports. Our original thought was Replication, but Axapta does not have primary keys on thier tables so Replication will not work. The...more >>

Hello, I'm new to replication. I have got a subscriber, publisher ans distributer working ok, so now does the snapshot replication, then the transactional ones. It was working fine for 5 minutes then I had the following error Cannot update identity column 'ID'. {CALL sp_MSupd_tblP...more >>

If I have a subscription to a publication (transactional) and the Distribution Agent tells me I need to reinitialize. What are the steps to do this?? Do I need to delete all the data on the subscriber?? If so, is there a way around this?? If not, what is the best practice of acco...more >>

Running - Win 2K / SQL 2K I am constantly, once a week or so,getting an error on a transactional publication that I have.... The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. This publication is set up ...more >>

I'm having an issue with this functionality. I've changed the directory where Snapshots are put on my publisher to 'C:\SnapShot'. When I generate a snapshot, the subscriber (A different server) can read it and apply it. When I use the sp_AddScriptExec to push a stored proc to the subscriber, the...more >>

Hello After restoring a publisher database, starting a merge-agent results in the error "The initial snapshot for publication 'XXXX' is not yet available. I don't understand this, because before I performed the backup, the initial snapshot was generated. When I regenerate the snapshot, every...more >>

We have developed a sales force system using SQL 2000 server in head-office and field using the HPC (SQL CE). Every day field representative makes some calls and replicate the data to head-office. Data of common clients from different users also get replicated. Normally users inserts around...more >>

Hi All, Recently one of our servers went down and I need to restore a database from backup. This database was the main publisher and distributor for a two server replication scheme. My question is if I restore the main publisher's table from a backup need I do anything to the subscri...more >>

I have three stored procedures that do the flowing tasks: 1. connect to and add logins for 12 remote (WAN) SQL servers 2. Drop data on the local server and re-add it table at a time from each remote server, one at a time, for 5 tables. 3. Disconnect from the sites. These stored procedure...more >>

Q: Push vs. Pull Transactional Replication We are currently utilizing a push transactional replication of a subset of the tables in a production database involving 3 machines; the publisher which is our production db machine with 4 hyperthreaded processors, 8 GB ram, a distribution db mac...more >>

Hello All- We have a SQL Server 2000 Merge publication with about 10 push clients running MSDE. There are 2 subscribers that appear to be failing when connecting to the publisher. The publisher & distributor are on the same host. If we look at the Replication Monitor, the 'duration' col...more >>

Hello I have configured replication in a test lab using three identical two processor based servers. One server is being used as the distributor. I am running an application on a fourth machine(laptop) that is directly connected to the Source Server. This application inserts records into the sourc...more >>

Is it possible to change the distributor for a publisher without affecting the publications? Example: D1 is SQL Server 2000 acting as distributor and publisher. X is SQL Server 7.0 acting as a publisher. D1 pushes subscriptions to X and also pulls subscriptions from X. D2 is SQL Server...more >>

I successfully implemented log shipping but am questioning the xcopy function over a point to point T1. Would it be better to use FTP? The database file is currently 6 gigs in size and takes awhile to copy over. We are doing this with SQL Server 2000 standard, so we don't get the extra features tha...more >>

Dear All, Yesterday Hilary said that its possible to remove the 'distributer' from the server, the reason is that I set the server as both Publication and Distributer, however the instruction I have (from Microsoft) state the Subscriber should be the Distributer. I know Hilary said it c...more >>

We have a Merge Replication with Publisher and Distributor on SQL Server 2000 SP3 and Subscribers running Personal SQL Server 2000 SP2 synchronizing through VPN phone lines. From time to time one or more subscribers can't reconnect to the Publisher. By inspecting their Merge Agents (through the Re...more >>

We are doing immediate updating transactional replication between a single publisher and a single subscriber. When we try to select SCOPE_IDENTITY or @@IDENTITY on the Subscriber we always receive NULL as the result. When we call them on the Publisher we receive the correct value. We have ...more >>

Hello, Hope everybody is doing ok. I setup a Merge Publication in my local network. I'm just wondering what would be the expected response time for the replication to ocurred. I know that this is difficult to estimate, but if I setup the merge publication to be checking for changes contin...more >>

Hi, I have a huge problem, the scenario is as follows: I am using Merge Replication via FTP. I have set up a publisher and subscriber sucessfully and both are synched and everything works perfectly. However, when I want to update a store procedure I use sp_addscriptexec as follows: ex...more >>

What is the syntax for changing an identity column in a table to "Not = For Replication"? Alter table x ??????? identity column, Not For Replication Thanx! =20...more >>

I am new to replication and have a couple of questions My requirement is to keep several (2 - 10) databases in sync. My current thinking is to use MSDE, along with merge replication. I have determined from the documentation that MSDE has the features and capabilities to fulfil the data storage a...more >>

My company maintains 40 replicated Sybase databases using a merge replication approach. It's difficult to update all 40 databases when a structure change occurs. Structure changes are minor, usually adding fields, however on occasion tables need to be added. We are considering moving to SQL Se...more >>

To Hilary: I've been eagerly awaiting your new book on SQL Replication that had been scheduled for April publication. Any idea when it will become available? Thanks!...more >>

I have merge replication set up on one box thath runs sql server 2000 sp3. I also use SQLSnapshot object to create initial snapshot. According to BOL snapshot agent: - at the publisher: must be in the publication access list of the referenced publication; - a the distributor: must be in the pub...more >>

Hi I recently recovered my SQL2000 Sp3 Merge Replication structure from a failure after adding a few new articles to my publication. Everything was going fine (getting everyone up again), until I noticed 5 out of the 100 sites with the following problem: The merge process could not retrieve c...more >>

We are trying to setup merge replication using separate servers for the publication and distribution. The servers are in the same domain. The same domain account is used oon all servers involved with the replication. The setup scripts perform the following task: Distributor (Master db) ...more >>

Running - Win 2K / SQL 2K I am constantly getting an error on a merge publication/subscription that I have.... The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. How can I prevent this from happening?? ...more >>

Hi everybody. I am working on merge replication first time and I ran a synchronizing processing and get error message: Cannot insert the value NULL into column 'objid', table 'ReplicationDB_1.dbo.sysmergeschemaarticles'; column does not allow nulls. INSERT fails. My snapshots has created su...more >>

Is it necessary for the table structure on the publisher from whom an article will be updated on the subscriber, have the same structure as the subscriber table?...more >>

2 SQL Server 2000 each on server 2000, 1 is the publisher, the 2nd is the distributor/subscriber in a Transactional Replication Both have the SP3 for SQL Both boxes have plenty of disc space. We upgraded to SQL 2000 on Saturday. Things ran fine until early Tuesday and Wednesday morning. In bot...more >>

Good day I am wanting to "replicate" user accounts between two SQL 2000 servers automatically. I.E. If I create a user on the first server, I want it automatically created on the second SQL server, if it doen't already exist Is there a quick and easy way to do this? If so how? I don't have to us...more >>

Hello, I have accidently set up our production server as the distributer. According to BOL its best if the subcriber is the distributer. Is there a way of turning the distributor option off ? Thanks Peter...more >>

Hi - I'm trying to do a replication synchronization between a SQLCE database on a Windows Mobile device and a SQL 2000 database on the desktop, and I'm getting an error 28010 - An instance of the SQL Server Reconciler error object cannot be created. The full error message and my relevant VB.N...more >>

I am running SQL 2000 I need to use a table "customers" in a merge replication publication in order to join it with a 'transactions' table. The problem is that the customers table is included in a transactional publication. Is this possible? Thanks Nik ...more >>

We've been getting a 22022 error on a replication snapshot agent job for the last day or so -- the job typically runs once per hour and does little, as it is intended just to check for subscriptions that are marked for replication and, if it finds one or more, to regenerate a publication s...more >>

Where can I find out the best method/setup to setup 5 SQL Servers, each with different databases into a single SQL server for redundancey and backup purposes. I'm not very experienced with Replication so I'm not sure which method to use (i.e. Multiple instances - one for each separate server, etc...more >>

Hi Guys, I'm currently running a dynamic snapshot replication over a 56k modem. I have built the snapshot and inserted the snapshot file to a USB key and applying the snapshot from the USB Key. The problem I am encountering is that, for every script file that is applied to the local database t...more >>

We have established a Report server (subscriber) for our OLTP production database (publisher). Transaction replication is running between the two databases. An UPDATE on the OLTP database is triggering a DELETE/INSERT on the Report database. This DELETE is causing a FK conflict and result...more >>

I have a new server, new instance of SQL on the network with an old server,old SQL db. I attempted to set up replication by creating a snapshot and making new server (Win 2k3) a subscriber to publisher/distributor. I get the following error: Invalid column name ', '. (Source: NewServer...more >>

Is it possible to have a server running SQL 6.5 as a subscriber where an SQL 2000 is used as a publisher?...more >>

I am running SQL 2000 in a stand alone Win2K server with merge replication. I created a local account with administrative rights to run the SQL Server and the SQL Server Agent. I am using SQL Male that requires me to set up a local account and Outlook 2000 profile for mail to work properly...more >>

hi, i am not certain what is purpose when the distribution database is configured with sync with backup. i understand from the help online that this will not truncate the publication database log. however, i can't achieve this. this is what i did in my testing. 1) configure distrib...more >>

Hi to everyone, Is auto identity range supported in publisher-subscriber scenario? In example: Server1 publish database1 with article Table1 with auto identity range. Server1 reserve itself the range 1-100. Server2 subscribe to Server1 and get and identity range 101-200. Server2 is also ...more >>

Hi All, I am unable to configure a pull subscription to a merger publication. I am using MSDE on both subscriber and a publisher. And I am using XP the operating system. When I try to set the snapshot location in the replication configuration wizard, it says that it is not a valid pa...more >>

Hello, We are experiencing a native exception during merge replication between SQL Server CE 2.0 and SQL Server 2000 SP3. Configuration: Windows Mobile 2003 ..NET Compact Framework SP2 SSCE 2.0 SQL Server 2000 SP3 The exception is an access violation, which occurs during the call to t...more >>

Hi friends, I have a problem with my Sql Server (Win2k Server, Sql Server SP3 updated) replication. My replication stopped with "The process could not bulk copy out of table '[dbo].[syncobj_....." message. What is wrong? Could anybody help me? Arda Han Software Engineer ...more >>

I am still struguling with shrinking a log file that is almost 5GB. The database is being replicated using merge replication. I ran the following commands without any success backup log Main_DB with truncate_only The log was not truncated because records at the beginning of the log are ...more >>

Hi All, I am getting an error message as below : **************************** Category:NULL Source: Merge Replication Provider Number: -2147200990 Message: The process could not deliver insert(s) at the 'Publisher'. **************************** This is then followed by a error (wi...more >>

Hi, I'm in the process of learning how to setup transactional two way real time replication. From this article: http://msdn.microsoft.com/library/default.asp? url=/library/en-us/dnsqlmag2k/html/Replication.asp I get this info, that staying on my way right now: "Another catch with SQL S...more >>

Hi, Hitting the following problem - do not know how to get around it. Have the main application running on a central SQL server - I take replica with me + need the latest update of the views and stored procedures etc. First I tried to replicate - but replica falls over - as I have n...more >>

Dear Sir/Madam, Hello, I'm a MCSA and administrator of a large scale company, we have two member server (with the same hardware configuration) that both have SQL Server. On one of these servers we have a SQL database that it stored more than 600,000,000 characters and everyday 700,000 charac...more >>