How to Run Snapshot Agent in Query Analyzer
Wed, 13 Aug 2008 22:46:01 -0700
my transactional snapshot agent is failing with "Server Execution Failed" and
"No Response in the last 10 minutes" I read in another post that I should try
to run the Snapshot agent in Query Analyzer so I can get a more useful
output. It sounds like great idea, but I don't know who to do it. The post
didn't ...
|
Urgent problem with Merge Replication
Wed, 13 Aug 2008 08:52:18 -0700 (PDT)
Hi,
We are running merge replication and yesterday I moved the publisher
from ServerA to ServerB, I recreated replication to ServerC as a
subscriber and ran some testing and everything seemed ok.
Coming into the office this morning I have found the following
message:
The schema definition of base table ' ...
|
Changing an article from download-only to bi-directional
Wed, 13 Aug 2008 07:01:05 -0700 (PDT)
I have a merge replication set up and I need to change one of the
articles from download only to bi-directional. I tried doing this
through SSMS and marked subscriptions for reinitialisation and
recreated the snapshot. However, when I tried to synchronise I got
errors:
"The merge process failed because it dete ...
|
Transaction Replication from SQL 2005 / 2008 to MySQL
Wed, 13 Aug 2008 04:10:01 -0700 (PDT)
Hey,
I've been investigating the possible way of getting transactional
replication from SQL 2005 or now SQL 2008 to MySQL working, and have
not been able to do this. In SQL 2000 I was able to get this up and
runnign but there was a documented problem when the distribution
agents restarted it would fall over, ...
|
Subscribers are no longer getting all update applied at the Publisher
Tue, 12 Aug 2008 17:01:36 -0700 (PDT)
Some of the database updates on the Publisher are not being downloaded
to the Subscriber. However, all the changes at the subscribers are
being uploaded successfully to the Publisher. But, when I do a
complete download to a new local database I get all the data from the
Publisher. We've been running live for ...
|
Oracle DB to MS Sql Server DB Replication question...with views?
Tue, 12 Aug 2008 15:16:47 -0700 (PDT)
Hi,
I'm not sure if this is even possible, but I've been asked to look
into replication from Oracle to Sql Server. He's the situation:
We have access to a remote Oracle database, but only read access (not
allowed to configure or change the db).
We own a Sql Server database with Views that use a link server t ...
|
installing latest SQL 2005 service packs tonight
Tue, 12 Aug 2008 13:55:32 -0700
i am going to install the latest sql 2005 service packs on 3 servers
that are using merge replication (they are one 9.0.1399 and i know there
are SP's after that). Is there anything i need to do differently on
those servers since they are using merge replication than i have to do
on a non-replicated machine - or ...
|
|
|
Replication problem and MSmerge_tombstone problems
Tue, 12 Aug 2008 13:04:10 -0700
We currently have SQL Server 2000 and have merge replication. We have the
following process
1. Data is transfered to a laptop, data on the laptop is changed and the
data on the server is 'locked'
no changes can be made.
2. After a few days, the laptop is returned to the office.
3. A script is ran t ...
|
IT Job Guru
Tue, 12 Aug 2008 12:19:49 -0700 (PDT)
Are you looking for a Job in India??? You have experience in Java,
Oracle, .NET, SQL Server, SAP and testing tools. Than you can wait a
minute and log on to www.itjobguru.com/forum/index.php. It has all
the
latest Jobs and also the Questions that will be asked in Interviews.
Or are you planning to do a cert ...
|
repl pending xacts on performance monitor
Tue, 12 Aug 2008 07:53:20 -0700
I looked at the performance monitor for Repl. Pending Xacts and there is
over 4billion transactions - there is NO WAY that there are that many
that need to be replicated, espeically since the other subscriber only
gets about 10,000 transactions per day.
Now, if someone hit re-initialize subscription instead of ...
|
