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 >>