Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / June 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
snapshot not working30 Jun 2007 23:50 GMT2
I'm trying to set up transactional replication using SSMS.  I had no errors
creating the publisher and distributor but had warnings when the subscription
create was running saying that another sa process was running.
I'm new to this and do not know how to get the snapshot to run ...
SQL 2005 Log Reader error 1880528 Jun 2007 20:06 GMT3
Firts we create 12 publication, each with many articles, all initialize and
sincronism ok.
After that, we just use one aplication to manipulate data at publisher.
Twice error 18805 appear. The Log reader can not execute and this message
is replication session a transaction?28 Jun 2007 13:49 GMT1
I am curious if a "session" for merge replication is a transaction.  If I
see 100 actions in the Agent History and the last one is "the process could
not enumerate changes at the subscriber" due to General Network Error
(dropped connection or whatever), did those 10000 data ...
automating snapshots28 Jun 2007 08:18 GMT2
I'm new to replication and maybe I'm missing something.
I set up replication from one server to another (push).
The replication is working fine every hour, but I have to start the
snapshots manually.
SQL Agent terminates, then replication can't restart.27 Jun 2007 17:32 GMT5
Our setup is pretty simple, one transactional box, a remote distributor, and
a reporting server using one way transactional replication, push
subscription, no immediate updating. (All boxes SQL 2005) Around 3am the sql
server agent died on the distribution sever with this message ...
How to?27 Jun 2007 09:34 GMT1
Is there a way where I can add a table to an existing publication in SQL
2000 (both publisher and subscriber) and get the transactional replication
to work without generating the snapshot of the whole database ? There are
few tables who have columns omitted from the existing ...
Replication implementation hurdles.27 Jun 2007 09:12 GMT2
We have a product that configures on SQL 2000 and also configures the
replication. We are in the process of doing R&D on SQL 2005.
Following are my machine specifications
OS Type : Windows 2000 Server (SP4)
Can't copy/export a database with identity *NEWBIE*27 Jun 2007 03:44 GMT3
I have a database where some tables have the IDENTITY = YES.
If I copy or export from ServerA to ServerB, the IDENTITY gets set to No.
This has to be a simple problem.
How is it fixed?
Merge replication error 132626 Jun 2007 23:04 GMT1
Does anybody know what could cause this error:
The schema script '\\SERVERP\ReplData\unc\SERVERP_ANIL_ANIL
\20070626175153\ZEZALOGADATUM_1.sch' could not be propagated to the
subscriber.
replication not working26 Jun 2007 21:42 GMT5
I set up a transactional, pull publisher, distributor and subscriber last
week on a development system and all worked fine.  Then, I did the same set
up on our production system and it is not working.  When this was started on
Thursday night the distributor would not start.  I ...
1 question26 Jun 2007 11:20 GMT1
I am using MCALL for updates sql statement, I know MCALL only replicates the
changed columns, however is it possible to force a certain column to be
replicated even there are no changes to it?
Thanks in advance.
Automate reinitialization26 Jun 2007 03:04 GMT1
Currently, we have many MSDE instances that subscribe to our main server.
Morning, we have to re-init whenever there's a failed subscription.
Is there a way or script to automate the reinitialization? Also, how can
we indicate it to use the current snapshot or generate a new ...
Merge Replication doesn't re-propagate changes coming from transactional replication25 Jun 2007 11:45 GMT1
I have the following setup:
OracleDB
SQL2005
SQL2005Express
MSREPL_Commands TABLE22 Jun 2007 19:03 GMT3
I don't think I ever resolved this issue & now I am quite concerned about my growing MSRepl_Commands table.
It has over 9 million rows.
What steps can I take to reduce the number of rows in this table?
Thanx!
Merge Replication Agents22 Jun 2007 16:52 GMT3
I have a system of 2 PC, with installed Win XP and SQL 2000. I
configured one PC as Publisher and Distrbutor, and the other as a
Subscriber with a "push" subscription. The snapshot and the merge
agents are running on the Publisher/Distributor. This PC is always ON
Pages: 1 2 3 4 5 May, 2007
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.