Hi, I have Database which is configured for Transaction Replication. My Database options are "AutoShrink". I have scheduled TransactionLog Backup Job Every Hour. I am unable to see the log is shrinking, it's growing alomost from day one. Ours is SP3A, and Clustered. Please advice me, fo...more >>

According to books online for SQL 2000, it is possible to use an attachable subscription database to create a new pull subscription. However, when I go into the property sheet for the publication (newly created, prior to any subscriptions) , there is no option to allow copying. The docum...more >>

HELP! I have just taken over mgmt of a SQL Server warehouse architecture that uses replication to propogate changes from a staging server to a production server. The replication has been broken since 04 Dec. When attempting to reinitialize the subscription, SQL tells me that I must drop...more >>

Hello All, Here's my question: how do I transfer ms sql 6.5 database from one server to another, same version of the sql? I have to replace a server, I've configured the new one pretty much the same way as the old one. Thanks...more >>

Hi I have been running Merge Replication with SQL200 Sp3a successfully for over 6 months now. We currently have 15 sites replicating to a central server with an average of 5000 transactions per site per day. Everything was going fine up until 3 days ago, when I got the following error on some...more >>

Hi, We run a merge replication using SQL Server 2000. In order to be prepared for crash situations, I am in the middle of testing several rescue scenarios. Presently I simulate a corrupted master database on the publisher. Due to the corrupted master db SQL Server is unable to start. I have...more >>

Is it possible to make replication between sql server and oracle when sql server is publisher and oracle is subscriber ? I tried but could not succeed. Best Regards, Luqman ...more >>

To learn and practice Replication, I am trying to create a SQL Replication of two SQL databases accross a WAN using two Laptop computers one is a Windows2000 Pro OS and the other is an XP Pro OS. Problem in authenticating between the two. Any pointers would be appreciated. Thanks...more >>

I have set up a dynamically filtered merge replication with pull subscribers. There is a filtered table called [station] that contains the name of the subscriber workstation and the filter is 'WHERE description = HOST_NAME()'. There is a [transaction] table that has a foreign key relation ...more >>

I have a database (DB1) that needs to be migrated to a new server. DB1 is involved in both a transactional replication scheme and a merge replication scheme (all tables except for three are trans, the other three are merged). There are currently 10 subscriber databases on other servers. ...more >>

I'm evaluating several replication possibilities, is anyone aware if SQL Server replication identifies database corruption before it goes and replicates it? For instance, if the server I am replicating has a database that is corrupted, I do not want that corrupted database to be replicate...more >>

Right after restoring dist db, pub db and msdb, logreader agent fails with message saying step did not generate any output? I tried sp_replrestart and stil l getting same error. ANy clue? How to resolve this problem?...more >>

Hi We use sql server 2000 , and I have been using transactional replication, One way with push subscription. This problem happens occassionally. When I try to add a colummn or add an article to a existing publication , the database hangs completely and totaly frezes up. No transaction...more >>

Hi We have recently applied SP3a to two of our SQL SERVER 2000 servers. Both machines are running on Win 2000 and neither had any previous Service Packs applied. Both machines are Publishers in merge replication. Once SP3a was installed the replication failed with the error message Could n...more >>

Hi all, I have a problem with making snapshot of a publisher database. When I start snapshot agent I get this error at the end: "The process could not bulk copy out of table '[dbo].[syncobj_0x4644453330353035]'. Invalid time format (Source: ODBC SQL Server Driver (ODBC); Error number: 0) I ...more >>

sql2k sp3 Im trying to truncate a tlog on a replicated db. It wont let me untill the results of dbcc opentran are empty. Im the only one on this test box and can verify that all data has made it to the subscriber. But still, even after 20 minutes of waiting, I run dbcc opentran and its n...more >>

Hello, I removed replication and then deleted a database. Now in my replication however I still have the snapshot and the merge but I can not delete the publisher because the db is no longer in the list. I guess when I thought I removed the replication I just disabled it. Any suggestio...more >>

Hello All, Please excuse this message if it is a little simplistic, but I'm very new to the concept of using the Snapshot API and SQL Snapshots in general. I'm after some information or advice regarding the API which is used to pause/resume the SQL Server for the purpose of carrying out a ...more >>

i have been trying to create a merge publication on a server. in fact i have tried many publications on this server. each time i do it, it goes through the steps to create the initial snapshot of the different tables. the steps it shows: Initializing connecting locking published tables.... pr...more >>

Hi , My name is Hamid and I am a Network administrator , My manager wanted me to Implement transactional replication between two SQl Servers ,I configured Publisher,Disributer and Subscriber and replication started successfuly ,, but my Database Relations and keys aren't replicated , I do...more >>

I'm trying to initialize a database across a WAN link. It starts copying and then fails after a Gig of data and about 40 of the 60 articles are moved. I set the -querytimeout value to 300, but it still failed. Any ideas on how to allow this job to finish would be great. ...more >>

we want to replicate between 2 servers that are not connected, temporarily, for a few months. ideally i would like to carry the information back and forth on a cd, either writing information directly on the cd, or writing on the hard drive and then coping a file to the cd. can anybody help? or po...more >>

sql2k sp3 I try this action and I get the message: Executed as user: domain\login. The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed. [SQLSTATE 010...more >>

hi, my error received is The Microsoft Jet database engine cannot open the file '\\Newhomebig\Desktop\test_Backup.mdb'. It is already opened exclusively by another user, or you need permission to view its data. I am doing a merge replication between a sql server 2000 and a access m...more >>

I need to setup replication Using IP addresses. When I try to configure distributor, it gives me an error distributor_admin not defined as remote login. When I checked the remote server properties, mapping is there. Am I missing anything?. Thank you for your help....more >>

I have to apply application changes made by the vendor to the SQL Server 2000 transactional replication database weekly. What sets should I take to stop and restart the transactional replication database? Thank You, Jeff ...more >>

I can't seem to get the status event for the class to fire in VB.Net. Is there a solution or is this a known bug....more >>

Hello, I am trying to setup transactional replication between two servers (both are SQL Server 2000 SP3). I have a problem creating a publication article that includes a table with unique index on computed column (not primary). The error "Create Publication Wizard" gives half way through ...more >>

I m facing a problem in implementing merge replication.. Your advise will be highly appreciated in this regard... I have a merge publication which contains only one table i.e voucher. I have enabled dynamic filter.. I created a pull subscription to this publication and applied initial sanp sh...more >>

I setup Transactional Replication on SQL 2000 Server. It works fine when replicating data to my destination table in subscriber. Then I setup a few tables with foreign keys reference to my destination table, I get error: "DELETE statement conflicted with COLUMN REFERENCE constraint 'FK...more >>

Hi, i'm setup merge replication between 2 servers. Two days it is work perfectly, but on 3 day we have syntax error in command generated by merge agent on five table in publication: "create table #belong_agent_-1864371812 (tablenick int NOT NULL, rowguid uniqueidentifier NOT NULL,generation...more >>

I have transactional replication set up to one destination server. Recently I added another subscriber and everything worked fine. After few days I tried to run snapshot agent again and got this error: "The process could not bulk copy out of table '[dbo].[syncobj_0x4644453330353035]'." I don't h...more >>

Hi everyone, I got error number 14114: SQL Server Enterprise Manager could not configure 'SERVERNAME' as the Distributor for 'SERVERNAME'. Error14114: '(null)' is not configured as a Distributor when trying to setup replication on my sql server. please point me direction how to fix th...more >>

I've setup merge replication between MSDE subscribers and SQL Server publisher/distributor. I will have up to 50+ mobile subscribers that will dock and syncronize. I will also have several 10+ Internet based subscribers. For my mobile subscribers, I've been looking for ways to make repli...more >>

Hi I have setup transaction replication, the log backup is scheduled every hour , but Tlog of publisher database is not shrinking.db option is autoshrink, SP3A Is there any way to calciculate wht's going behind the scenes. Thanks ans Merry Christamas!...more >>

I am having a problem with SQL server 2000. I have several databases where the mdf and ldf files were deleted using windows explorer. The databases show as suspect in Enterprise manager but when I try and delete the database I get a message that I cannot delete the DB because it is setup...more >>

I have a setup where the SQL Server Agent's startup account is the system account. If I setup my publisher through the enterprise manager I get the error that the SQL Server Agent on <publisher> currently uses the system account which causes replication between servers to fail. I hit OK,...more >>

Dir All, I want setup a replication system over internet. how could I do? Thanks for help. Best regards. TN...more >>

Hi! I was wondering if anyone could help me. I am going through the nightmare of having to setup transactional replication on several hundred objects (i.e. stored procs, views and tables) that have different ownership. If i set up transactional replication, by default all my objects will be assi...more >>

I have a large (2 gig) database on 1 server that the customer wants to replicate to another server in a different state. I have looked at the different replication options and wanted to use transactional, but that doesn't allow the subscriber to update image or ntext columns - and I have to allo...more >>

I repeatedly get this error in the application event log. The server is one of a two cluster that is log shipping to a third server. These event items appeared only after log shipping was started. Source: ClusSvc Event ID: 1137 Description: Event log replication queue OUTQ is full. 1 ...more >>

Hi, Is it possible to setup replication if the data in the subscriber database tables are being updated, but you do not want to have the changes merged back to the publisher? Thanks, Hillel...more >>

Our problem is the order of applying changes from subscriber to publisher and back, regarding FK constraints and parent-child relations. We have 234 articles in publication and if we take a look at table nicknames (SELECT nickname, name FROM sysmergearticles ORDER BY nickname) we can see th...more >>

Hello, I have been running into an issue where I keep getting the following error: The subscription to publication 'test' is invalid. I have added the server that I am performing a 'push' replication to within the Network Utility for an alias name due to DNS problems, but still I am g...more >>

Hi I want to shrink a database that I have that is currently being published. I have about 19 GB worth of data in about a 55 GB data file. I want to shrink the database so that the database file is about 19 GB. Is this possible to do without interrupting replication? Do I need to ch...more >>

I am trying to setup immediate update transaction replication without going thru initial sync process. I executed the result from 'sp_scriptpublicationcustomprocs' on the subscriber to create the sp for sp_msins...,sp_msupd..., sp_ms_del.., then I tried to execute 'sp_script_synctran_commands...more >>

I'm new to replication. But my problem is that I have a database on a web server that has data being replicated to it from an internal database. It seems that when a replication occurs, my permissions that I've set up on the web database gets wiped out and I have to go back and reset them....more >>

I have merge replication running with 2 servers (both W2K SP4 and SQL2000 SP3). I got no problems setting it up and it ran perfect since some weeks. But yesterday I got this error message, every time the merge agent tries to merge the data: "Failed to enumerate changes in the filtered arti...more >>

Hello, I am trying to set up transactional replication where the agent that synchronizes the subscription are at the Subscriber but I can't seem to set it to work. I get the following messages: On the server where the distribution database is: Login failed for user 'NT AUTHORITY\ANONYM...more >>

hi, i have one sql2000 server and several msde-clients, which use the merge replication. if i import data from a text file using the dts-import wizard, the newly imported data will not be replicated until i create a new snapshot and reinitialize all subscriptions. data inserts done by a ...more >>