Replication

SQL 2008 to SQL 2000 Merge Replication
We currently have SQL 2000 to SQL 2000 merge replication. Can we upgrade the publisher to SQL 2008 and still do merge replication to sql 2000 subscribers? ... 21 Jan 2010 14:36

metadata cleanup 2147199401
Message-ID: <23bce490eb754ada94664e2dc6dfb612(a)newspe.com> X-Mailer: http://www.umailcampaign.com, ip log:81.82.229.3 Newsgroups: microsoft.public.sqlserver.replication NNTP-Posting-Host: 22.bb.5446.static.theplanet.com 70.84.187.34 Lines: 1 Path: news.netfront.net!news.glorb.com!news2.glorb.com!news.alt.... 19 Jan 2010 03:35

possible resolution
Hi, We had exactly the same error after performing metadatacleanup manually at the publisher and the subscribers. After some trial and error, we found out that the field cleanedup_unsent_changes in table sysmergesubscriptions at the subscribers contained 1 instead of 0. So resolution to fix our issue: - backup ... 19 Jan 2010 03:35

ogical consistency-based I/O error
I received this error message from one of my SQL 2005 Servers ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x334e4db8; actual: 0x174eeacc). It occurred during a read of page (1:22084) in database ID 12 at offset 0x0000000ac... 21 Jan 2010 15:45

WITH FILLFACTOR is missing when snapshot recreates indexes
Hi, I set up transactional replication between two databases. When I applied the generated snapshot to the subscriber, I realized that the indexes were re-created but the WITH (FILLFACTOR=90) were missing in the indexes definitions. In the publication, I configured the "Copy clustered indexes" and "Copy ... 15 Jan 2010 14:57

Snapshot Location
I know that I can alter the location of a snapshot both by setting the default snapshot location, or by specifying the alt_snapshot_location parameter. However, both of these only specify the beginning of the path (e.g., E:\MSSQL\REPLDATA). What I'd really like to do is determine where the snapshot was actually s... 15 Jan 2010 10:28

Transaction log replication
Hi, I am setting up transaction log replication with a view to having a failover/reporting server available (more reporting really as failures are relatively rare). As such we are pretty much sending across everything, including stored procedures. Unfortunately we are getting a lot of syntax errors such as "O... 15 Jan 2010 16:04

Poor performance in updating>20k records in SQL2k5 Oracle repl
After testing, the replication works fine with Oracle9i with table over 160k records while the performance is really poor in Oracle10G. Does SQL2005 oracle replication function support Oracle10G? Seems the replication PROCEDURE PollEnd doesn't work well in Oracle10G and made the perofrmance degrading. "hil... 6 Jan 2010 09:08

Missing @bitmap parameter
What causes trans replication to throw up the error below?? And how to fix it without dropping the article, re-adding it & manually syncing?? Procedure or function 'sp_MSupd_TableNameHere expects parameter '@bitmap', which was not supplied. AHIA, Larry... ... 25 Dec 2009 14:44

Subscription can't be created
A customer of ours receives the following message as soon as we try to add a subscription to a compact framework database. The process could not initialize 'Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver'. Verify that the component is registered correctly Is anyone familiar with this problem and... 18 Jan 2010 04:16