all groups > sql server replication > october 2006 > threads for october 29 - 31, 2006
Filter by week: 1 2 3 4 5
SQL 2005 MERGE REPLICATION
Posted by Nazeedah at 10/31/2006 11:18:01 PM
i have a replication "rep1" which is done for a table named "customer"
i have to have another replication "rep2" done for 2 tables name "customer"
and "supplier".
Both publications is found on the same machine that is machine A and both
subscriptions is found on mahine B
The replication rep1... more >>
MSDE and replication
Posted by TM at 10/31/2006 10:26:26 AM
Does anyone know if MSDE can use replication of any kind? I'm looking to
gather up many tiny databases and pull them into a larger 2000 box that is
Processor licensed.
I read that you can set up replication manually using scripts, but the
document didn't go into much detail.
... more >>
Replication Monitor Times and Handheld Synchronization times
Posted by savvaschr NO[at]SPAM nodalsoft.com.cy at 10/31/2006 7:10:33 AM
Hello
When i am Synchronizing(SQL2005 merge replication)
I can see the duration of the Synchronization on the Replication
monitor and i can see that lets say an "initial loading" of the
database with lots of data is taking 4 minutes but on the handheld if i
take the time of the Synchroni... more >>
adding articles
Posted by michael.swinarski NO[at]SPAM cox.com at 10/31/2006 5:57:55 AM
I am using trasactional push replication on 2005.
So, first I do this:
EXEC sp_addarticle
@publication = N'azDSS', -- Change value with the name of the
publication we wish to add to
@article = N'tbPhxSrvrpf', -- Change value with the name of the
article we are adding
@source_owner =... more >>
Server to server backup
Posted by angelin at 10/31/2006 12:00:00 AM
I need to take backups of all DBs in the server into another serve, which
should be done automatically once a particular period of time(say 30 mins or
2 hrs or 5 hrs etc..).
Please help me to do so with step by step explanation. iI am new to SQL
Server.
--
Regards
Angelin Enita.A
... more >>
SqlCeReplication.Synchronize() error
Posted by John A Grandy at 10/30/2006 6:15:11 PM
I've completely removed replication from the publisher/distribution server
and reconfigured a number of times, however my Windows CE 4.21 4.21
Windows Mobile 2003 Second Edition (Pocket PC 2003 SE) still triggers an
error on calling :
SqlCeReplication.Synchronize()
"A request to send dat... more >>
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION...
Posted by Adam Patrick Cassidy at 10/30/2006 1:39:39 PM
http://support.microsoft.com/kb/902320/en-us
This article is titled "The Snapshot Agent fails and a "The COMMIT
TRANSACTION request has no corresponding BEGIN TRANSACTION" error message
may be logged in the Snapshot Agent log in SQL Server 2000" and is exactly
the problem that I have. Howe... more >>
Error 28549 and Enforce For Replication, Help needed.
Posted by savvaschr NO[at]SPAM nodalsoft.com.cy at 10/30/2006 2:27:53 AM
Hello
I have a database of 52 replicated tables .
I am using several filters on my Merge Replication and I can
synchronize my handhelds just fine.
The problem is that after some updates of the my main database(SQL
2005) when i try to synch the handhelds i get an 28549 error for a
table.
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Replication between SQL 7 and 2005
Posted by Mike at 10/30/2006 12:21:44 AM
Hi i need to know how would it be possible to configure SQL 2005 and 7 to
replicate with each other.
SQL 7 will need to be the publisher and SQL 2005 will be the subscriber. SQL
2005 will not update back any data to SQL 7 but just read the changes made
and store it into the sql 2005 databas... more >>
208 Error - When Trying to generates Snapshot...
Posted by BATMAN at 10/29/2006 1:01:01 PM
Snapshot Error Details:
-----------------------------
Invalid object name 'sysarticles'.
Invalid object name 'sysarticles'.
(Source: SQLServer2B (Data source); Error number: 208)
--------------------------------------------------------
Thanks!
Michael... more >>
|