Replication

Peer to Peer replication for partitioned table using sliding windo
I have 2 servers (server A and Server B), both with one database that contains two tables (we'll call them MainTable and StageTable). These tables are partitoned using the same partiton schema (1 partition per month for the last 2 years using range left = 25 file groups and 25 data files). I can set up the p... 17 Feb 2010 02:16

Peer2Peer. Dist to Sub 'Query timeout expired'
Greetings all I have P2P set up, SQL 2008 Ent, 2 peers, been working well for a month or 2. After a recent large 'update' statement affecting 25k large records, data hasn't made its way to the subscriber after some 10 hours. These records can be 800k in size. (Yes i know this probably should have been in chun... 14 Feb 2010 07:22

Updatable subscription issue - Either no algorithm ...
SQLException: Either no algorithm has been specified or the bitlength and the algorithm specified for the key are not available in this installation of Windows. Replication was running fine and this morning all subscriptions were failing with this error? ... 11 Feb 2010 12:48

REPOST - Agent message code 20084. The process could not connect to Subscriber
All servers running SQL 2005 SQL server (NOLA) replicates to 35 remote locations (StoreXX). Earlier this week, one publication started having problems connecting to 30 of the 35 remote locations, with an error of: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Date 2/4/2010 10:00:01 AM Log Job History (... 10 Feb 2010 13:25

a brand new query tool is out on beta, we need feedback, so you get a free copy
We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the above web page, but basically, its a very ambitious project to create what we call 'the query tool to end all query tools': everything you ever wanted, desired, dre... 8 Feb 2010 12:14

S2k5 -> s2k8 failuure
We're in the process of relocation some SQL servers & upgrading from 2k5 to 2k8. I've created a number of transaction replications that are working well, but one is failing. The publisher & distributor are both configured on the 2k5 server. I connected from the 2k8 server & created a push transaction subscripti... 8 Feb 2010 11:06

Replication between Sql 2005 publisher and SQL 2008 suscriber
Hi. I have two servers in different locations running SQL Server 2005 merge replication. I need to upgrade the suscriber server to SQL Server 2008. Is there any consideration I should make? Will replication continue working as it was before now with SQL server 2005-publisher and Sql server 2008 subscriber? Tha... 5 Feb 2010 11:40

Agent message code 20084. The process could not connect to Subscriber
All servers running SQL 2005 SQL server (NOLA) replicates to 35 remote locations (StoreXX). Earlier this week, one publication started having problems connecting to 30 of the 35 remote locations, with an error of: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Date 2/4/2010 10:00:01 AM Log Job History (NOLA-Closing_Bala... 4 Feb 2010 15:43

a brand new query tool is out on beta, we need feedback, so you get a free copy
We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the above web page, but basically, its a very ambitious project to create what we call 'the query tool to end all query tools': everything you ever wanted, desired, dre... 2 Feb 2010 16:05

How to replication in MSSQL 2005 on local network ?
Hi SQL Monster, I have 2 database server. One run real time I want to create replication on local network for snapshot or merge Can you help me ? You can sample for photos Best, phuongnguyen -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/201001/1 ... 2 Feb 2010 16:05