Hi , Recently due to storage problem i had to move all the databases to local disk. The databases were in merge replication and the server was where the replication was set. I generated tje scripts for the replications and disabled the replication on the server. After moving the databases...more >>

I have (3) subscribers out of a total of 185 that are failing on syncing. The error occurs when trying to apply a script to the subscriber. The script was posted using sp_addscriptexec. The schema script '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' could not be pro...more >>

Hi everybody, Could you please advise me what would be the best method to synchronize MSSQL data in the following scenario: SiteA (live site) ----- T1 link ----- SiteB (redundant site) Each site consists of web server and MSSQL 2005 server. SiteA is the site that my customers normally u...more >>

Hello, I sent this massage to microsoft.public.sqlserver.server but this group will be better for this problem. I can't backup log. I tray normal backup log to disk, backup with no_log (clean log without backup). I know where is problem but don't know how resolve it. My problem cause open t...more >>

I've inherited a project which has numerous fields that have extra spaces in them -- this is causing a problem with data Inserts, Edits, and Deletions in my .ASP Website. I'm importing data tables from ACCESS 2003 into SQL Server 2005, and I need to know if there's a way that I can Right Tr...more >>

I'm at a place where they are (SS 2000 SP4) replicating from one drive to a different drive. But, come to find out, that really the way the SAN is laid out, these drives could very easily all share the same spindles/heads. Now that's madness isn't it? Even with cache, isn't this asking fo...more >>

Hi, I would like to know if 2 SQL servers residing in 2 different networks replicate? If yes, Pls provide information for the same. Vibhu....more >>

I have a table in a merge publication with 11 subscrber. I need to modify the primary key of the table. Now the table have a primary key of one column. I need a primary key of two column. How can I do ? Thanks ...more >>

Here's out situation: We have a database with about 50 million records, full text indexing is enabled for one column. About 200,000 new records are added every day replacing an equal number of records that expire. All updates to the database will be directed to the master server database, so ...more >>

Hi, I have a replication table. However one of the field's datatype needs to be changed. The system does not allow me to do so. However I must change the field. How can I do so? Thanks...more >>

Does anybody know the best way to query the system tables to count reinitializations that have occurred? We are beginning to have some performance issues with our replication setup, and we are trying to find some trends (we have been archiving off the data from the system tables, so we have...more >>

We currently run one SQL Server. We would like to add a second for redundancy. This server would be located at a separate office connected by a Frame Relay, so it would be on a different subnet. Can someone suggest the best way to accomplish this? Thanks...more >>

In the Books online it says : Replication is a set of technologies that allows you to keep copies of the same data on multiple sites... Could someone give me an answer on what is the 'set of technology' that keeps the transactional replication running. Does it use DTS packages (or Integrated ...more >>

We have a merge replication system with: 1 (2K5) Publisher 100+ Pull (2K) subscribers (U.S. & Canada) 89 tables replicated LAN (VPN) network Our "logical" topology is really a multi publisher to single subscriber, but since that's administratively not feasible, we reverse it. Each time a n...more >>

Hi, I have a transactional replication with 2 subscribers and I want to filter the data to one of the subscribers but I cannot do it with the row filtering options on replication because it doesn't allow join filters which are only allowed on merge replications so how can I do that with tra...more >>

Hi are running Sageline 200 with sql 2005 backend. On out system, we have two companies,each in a seperate database, both with identical tables and schemas. I want to replicate some of these tables inro a single table on a remote server i.e. db1.dbo.stock and db2.dbo.stock onto a remote...more >>

I'll be doing an in-place upgrade of a couple SQL 2k boxes in a couple of days. One has a publication/subscription that the other box pulls. Should I do my SQL 2k5 upgrades in any particular order? For example, do the subscriber box first then the publisher, or vice versa? Do I need to dro...more >>

Hi, I have a sql server 2000 SP4 publisher and a sql server MSDE SP4 subscriber. After applying the initial snaphot I can see the inserted record information remains in the msmerge_contents table. Is this normal behaviour? Is there a way to prevent this. Our database is approximately 800MB a...more >>

I deleted about 3 million rows out of a table that is being replicated. So now, it is sitting replicating those 3 millison deletes to the 2 subscribers. What can I do to get it to stop replicating all of those deletes and start replicating the actual changes that have occured over the past two d...more >>

We have a CE .NET application that uses a local SQLCE database. Tee local database replicates to Merge replicated db. The Publication is set to expire every 14 days. If the CE device tries to replicate after the 14 days do we need to re-initialze the local database? Or will replicate handle...more >>

Hi, I'm getting the error: Error 14294: Supply either @job_id or @job_name to identify the job. Any idea to solve this problem. Thanks, Serge ...more >>

I am using SQL 2005 as pub and SQL EXPRESS as sub with Merge replication. Got the following error message The schema script 'CD_InTransit_v_153.sch' could not be propagated to the subscriber. Error Detail: The schema script 'CD_InTransit_v_153.sch' could not be propagated to the subscribe...more >>

You have to be extremely careful with the DDL scripts that you are executing if you are propagating schema changes through the merge engine. The gory details are all wrapped up out here: http://www.mssqlserver.com/replication/alert_merge_ddl.asp -- Mike - mhotek@mssqlserver.com MHS Ente...more >>

Hello everyone, I've a problem regarding the merge replication process when using the column level tracking, on either SQL Server 2000 or 2005 (the behaviour is exactly the same). I don't know exactly what I'm doing wrong here. I created a publication (Server A) on single article with colum...more >>

Hello. I have a merge replication scheme, where the synchronization request = makes the clients. I need that when finishing the synchronization, in = the publisher executes a procedure. Somebody knows since I can do this? Thanks Miguel...more >>

I am scratching my head on the documentation. Does it make sense to have either the primary or secondary sever in STANDBY? If so, how to do that? how to verify status is STANDBY? Thanks....more >>

SQL 2005 Can one transactional replication publication be sent to multiple distributors - not direct to multiple subscribers? Basically we are not allowed to place a local distributor on the source database server. We are looking for ways to utilize have multiple publications on the same sou...more >>

We are running a three publication on our head office server (SQL Server 2000) with four subscriber at different location. We just bought a new server and want to replace the old server with new one. Is there is any way that I can move the publication from the old server to new server with...more >>

Hello Everyone This is cross posted in MSDN Forums.... SQL 2005 SP2 Dev/Ed, 32-bit. Transactional replication, R/O, with no filters of any kind. in Log Reader Agent profiles I can not find MaxCmdsInTran parameter listed anywhere in SQL ManStudio UI. What am I missing? I look under di...more >>

Hi, We are thinking of using SQL 2005 Merge Replication. Some of our tables can possibly have larger rowsize as they have NTEXT columns which will be populated with a lot of data. How do we get around the limitation? Does Repliation completely fail in such a situation? Is there a way to le...more >>

hi all, i got below error when trying to configure distributor on my mssql 2000 server. error 14113: could not execute "c:\...\osql" -E -I60 -t60 -d"distribution" -b -i "c:\..\instdist.sql" -o "c:\..\instdist.out". Check 'instdist.out' in the install directory. any ideas on what is c...more >>

We plan to have two stand-alone servers (primary and failover) run MSSQL2000. We want to use replication to keep the failover server up-to-date. When something happens to the primary server, we switch the connections on the application server to point to the failover server. The users shoul...more >>

Hi all, I got error from the merge replication when I tried to synchronization article with blob data (varbinary(max)). The error said, The merge process could not replicate one or more INSERT statements to the 'Subscriber', A stored procedure failed to execute. I tried to use profiler, but...more >>

I am getting Msg 8115, Level 16, State 1, Procedure sp_replmonitorrefreshagentdata, Line 327 Arithmetic overflow error converting numeric to data type numeric. Upon debugging the problem I came across sys.fn_replgetpublicationthreshold. The reason why I am looking at this is because it us...more >>

Good Day, I am using SQL server 2005 with transactional replication to another server. I have a third server acting as the distributor. I would like to shut down the distributor server to install a hard drive but am unsure on what this will do to the replication. If I shut down the server w...more >>

Now I have this errors: * The schema script '\\CBA01\ReplData\unc\CBA01_gcg2_gcg2\20070914120826\DetOrden_587.dri' could not be propagated to the subscriber. * ALTER TABLE statement conflicted with TABLE FOREIGN KEY constraint 'FK_DetOrden_Ordenes'. The conflict occurred in database 'gcg2'...more >>

Hi I have now learned how to create a merge replication and manage a distributor, a publisher and a subscriber. All successful. Great. However, I tried it only on a small test database, and now I would like to bring back the databases on the 2 servers back to completely normal situation. ...more >>

Hi All, I'm trying to build a transactional replication environment, using SQL Server 2000, SP4. I'm getting the error "Error executing a batch of commands. Retrying individual commands". It's occurring right at the end of the process (after all of the DRI scripts have been applied), so I'm n...more >>

Hi everyone, I need to run a script in the publisher each time the snapshot is *generated*. Any ideas? Thanks for the info... José Araujo. ...more >>

Hi, In SQL 2000's Replication Monitor, I could watch the Distribution Agent durring initial snapshot synchronization and watch the "Last Action" to see what table was being currently pushed. In the SQL 2005/2008 Replication Monitor, I've found the Subscription window, and it tells me tha...more >>

Hi, I have transactional replication set up on on of our MS SQL 2000 (SP4) Std Edition database server Because of an unfortunate scenario, I had to restore one of the publication databases. I scripted the replication module and dropped the publication first. Then did a full restore. When...more >>

hi all, I have a need to set up transactional replication for reporting purposes. Reporting server is on the same LAN but we will like to use dedicated cross-over between servers for replication purposes only. How can I pursue distribution agent to use that NIC only? tia...more >>

Hi, I have the following setup 1x SQL2005 server running in 80 compatibility mode which is the publisher and distributor to 5x SQL2005 push subscription servers. Originally the publisher was listening on port 1433 (std SQL port) the port was changed to 4449 as another server DTSs data ...more >>

Hi, I fully expect the answer is no, but I'll ask anyway! We have a publisher (also distributor) server using SQL2000 SP4, which utilises Snapshot and Transactional replication to a SQL2000 box at our hosting site. The hosting site box will soon be replaced by two SQL2005 boxes which wil...more >>

hi all, i got this error when trying to set up publisher and distributor. `Because SQL server agent on 'SERVER1' uses the system account, SQL Server replication between servers will fail. To use the replication between servers, select another server to be the Distributor for 'SERVER1'. ...more >>

Hi, I get this "Action Message" when I look at the "View Details" for a transactional replication agent: The concurrent snapshot for the publication '[publication name]' is not available because it has not fully generated or the Log Reader Agent is not running to activate it. If generat...more >>

When I try to alter a table with: DECLARE @Beg datetime DECLARE @End datetime SET @Beg = getdate() ALTER TABLE __TABLE__ ALTER COLUMN _COLUMN_ VARCHAR(250) SET @End = getdate() PRINT DATEDIFF(second, @Beg, @End) I get the message: Warning: The table '__TABLE__' has been created bu...more >>

Hi! I'm struggeling on getting an Windows Server 2003/SQL 2005 publication up and running. I have created a windows account on the server, and I am not sure what privileges I should grant this account to make it start. Using this guide: http://technet.microsoft.com/en-us/library/ms1723...more >>

We have a server set up using merge replication with 20 client subscriptions. The publication is filtered with a very simple hostname filter. We are experiencing some reliability issues that I would appreciate some feedback on. Occasionally when synchronising the clients appears to lose conne...more >>

Guys, I just setup a new transactional replication between two of our sql boxes. As the db is quite large (80GB). The snapshot folder is about 80GB as well with the DB 80 GB as well. so in total i am using 160 GB of space. The replication is working fine.But i was just wondering if i can d...more >>