|
Virus string in Subscriber data -help serverI got hit with an Injection attack. Cleanup is almost over except that in a local publication I get this is the connection string: Servername\Replication\Local Publications\[servername]:tempdb\[<script src=http://www.bywd.ru/js.js> Everything from <Script.. onward is part of the Injected string. I ... 29 Aug 2008 14:44
Schema Only Snapshot Is it possible to create a snapshot for merge replication that would apply the changes necessary for replication without deleting the data in the subscriber database? The scenario is this - a client application has a database that will become the subscriber. That database has existing data that needs to be sen... 29 Aug 2008 12:40
Failed to enumerate changes in the filtered articles I have SQL Server 2000 build 8.00.908 and one of my Merge publications has developed the error "failed to enumerate changes in the filtered articles". Further details give the following msgs: "Incorrect syntax near the keyword 'where' and "incorrect syntax near the keyword 'and' ". The last command field displa... 28 Aug 2008 22:23
Maximum Retention period of the distributor DB (transactional repl Hi Emmanuel, From BOL: ------------------------------------------------------------------------ Transactional replication uses the maximum distribution retention period (the @max_distretention parameter of sp_adddistributiondb (Transact-SQL)) and the publication retention period (the @retention parameter of ... 28 Aug 2008 04:57
2 databases merge at night Is it possible with any version of SQL server to have 1 database in headquarters and 1 db in a remote site and have them do a scheduled merge everynight over the vpn connection. Both sites will access (read/write) thier local db during the day? Thanks for any help ... 28 Aug 2008 06:59
Making single table snapshot using sql server 2005 enterprise I have created a publisher and snapshot some of the tables, which are published to a subscriber. Now I would like to snapshot a single table for this publisher. I checked the table and start the snapshot agent, but it starts to snapshot all the tables taht were snapshot before. Is ther some way to do this with... 28 Aug 2008 17:16
Field size too large error While applying the snapshot to the subscriber, I get an error saying The process could not bulk copy into table '"dbo"."MSmerge_contents"' and then "Field size too large" Can some one give an explanation about this error? The publisher is SQL Server 2005 Std (SP2), the publication is partitioned (vi... 27 Aug 2008 08:27
Error in replication Hi, We have a merge replication system in place. Remote users synchronize their database. Suddenly one of the user is getting the following error: Synchronizing your database to the Master database -- 8/26/2008 3:50:35 PM Setting up to Sync non-PWO tables from Master to Laptop. Copying selected data from M... 26 Aug 2008 16:06
Timing problem running sp_addsubscription programatically We use a DBUpgrade program to maintain our database schemas. Part of this process is to configure replication. On our test servers we often configure the publisher, subscriber and distributor on the same physical server. When doing so we are bumping into a timing issue with sp_addsubscription. We call ODBC ... 26 Aug 2008 11:57
Replication Issue Also Have you had any success with this. I am encountering the same problem. ... 26 Aug 2008 10:56
Manage Subscription Files Greetings, I am new to replication and have not been able to find a topic on managing the size of a publication. I have a snapshot setup of SQL 2005 and a subscription which are working fine. The files in REPLDATA though will continue to accumulate over time, filling available space. Other than manually d... 26 Aug 2008 09:54
Maximum Retention period of the distributor DB (transactional replication)does not work Hi, I tested the Maximum Retention period of the distributor DB but my test failed and I would like to know why? Here after the scenario that I performed: I set up a transactional replication with a pull subscription. I set Maximum Retention period of the distributor DB to 1hr (the default is 96hrs). I run a... 26 Aug 2008 09:54
Help to Remove Replication Distribution database files were lost because of the disk failure. We decided to remove completely replication from the server. I used exec sp_dropdistributor, sp_dropdistributiondb, sp_removedbreplication I also run delete msdb..msdistributiondbs After all, I do not have any records in select * from master... 27 Aug 2008 14:37
Can't change server name for publication & subscription I have two SQL servers, one that publishes parts of a database to another SQL server to help offload some of the work. Tonight i am renaming my SQL server with the subscription, but when i look at the properties for the Publication on the other server, the old server name is in there, and it's grayed out so i ... 25 Aug 2008 17:33
troubleshooting Transactional Replication Latency Hi everybody. SERVER_A: Windows 2003 Server with SQL Server 2005 SP2. This is the corporative server for all our data. About 30 tables divided in 4 publications. Each publication contains the tables belongs at the same database. This is the suscriber of one publication I describe below. SERVER_B: Windows 20... 23 Aug 2008 13:30 |