|
|
|
April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Transactional replication reliabiliy Posted by andsm at 4/6/2007 4:24:01 AM I thinking of usage of transactional replication in one of projects. The
transaction replication will be used between several servers. Most of servers
(TransDBs) will be used for entering data (high writing activity, lots of
concurrent users on each of the servers), and data from the servers, ...more >>
Turn OFF Automated Conflict Resolver in Merge Replication Posted by Aubrey at 4/5/2007 6:48:02 PM How do we change from Automatic to Interactive Conflict Resolution in an
Anonymous Merge Replication scenario? The Subscriptions are created locally
with Windows Synchronizer, which has that choice in the Properties (real joy,
as that must be done by an Administrator). How do we change Enterpr...more >>
Replicating to Already Existing Table in Subscriber Posted by Sal at 4/5/2007 5:06:01 PM Hi:
I am trying to replicate a table which already exists in subscriber
database. I want to make sure that I don't overwrite the table schema on
subscriber table. How can I do that? I am using sql 2005. When I add an
article in TSQL, how can I ensure that table schema is not sent across...more >>
Problem with replication job schedule Posted by David Tilman at 4/5/2007 10:14:04 AM We have recently setup a snapshot replication on a SQL Server 2000 server.
It's an unusual replication, since it's replicating from one database to
another on the same server (because of the interaction between two 3rd party
applications).
My problem is that when I set the job schedule's "e...more >>
What is implication of infinite subscription retention in Transactional replication Posted by Lavanya at 4/5/2007 5:35:42 AM Hi,
I have a setup with central subscriber and mutiple publishers in
Transactional replication.
By default, if i have the following settings, i understand my
subscription would get deleted after 14 days.
Transaction retention = 30 days
Subscription retention = 14 days(default)
History re...more >>
Indexing job interferes with log shipping Posted by thejamie at 4/5/2007 4:16:00 AM The log shipping job fails right after indexing runs and the log file itself
turns up corrupt. Is it possible to run a command that temporarily disables
the log shipping while indexing runs and then upon completion of the indexing
(fail or not) re-enable the log-shipping job?
--
Regards,
...more >>
Replication with Advanced Express Edition Posted by Gilbert at 4/5/2007 3:24:01 AM I cannot create a publication with Sql Server 2005 express advanced edition.
Is that normal ?
I'm getting (under Vista) an error that some components cannot be installed
because IIS is not active. I checked and my local IIS 7 is active.
Any help please ?...more >>
what account does replication use to subscribe to? Posted by Hassan at 4/4/2007 10:56:47 AM When I use transactional replication and push data to a set of subscriber,
what authentication does the publisher( w/ distributor) use to connect to
the subscriber ? Is it SQL Auth or Windows Auth ? If SQL, what is the
username ? If Windows, is it the SQL Server or SQL Agent Service Account?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error: Another merge agent for the subscription is running Posted by tpapad NO[at]SPAM gmail.com at 4/4/2007 8:32:52 AM Hello all,
We have implemented a merge publication with merge agents
synchronizing over a slow WAN connection. The connection seems to be
rather unstable and users often disconnect during synchronization.
When they try to repeat the process (after the connection is re-
established) they get t...more >>
resolver option and tracking level article options disabled Posted by nkleinjan at 4/3/2007 9:24:00 PM Hi, we are using SQL2005 merge replication, and have 2 publications that
reference the same article. We are trying to change the tracking level option
for this article, but it is greyed out and disabled, because it knows the
article is in another publication, and it disallows this change. We r...more >>
sql2005 merge subs suddenly expired-- Posted by S c o t t K r a m e r at 4/3/2007 8:59:36 PM Please help!
All my laptop subscribers suddenly expired? also the replication monitor
looks strange... the sub names are blank
Anyone recover from this without re-subscribing?... no changes to the server
for 27days...
Thanks!!
TITLE: Replication Monitor
-------------------------...more >>
Urgent issue: Removing a remote server Posted by PromisedOyster at 4/3/2007 6:24:35 PM Ref: SQL Server 2000 Standard Edition
I want to remove a remote server (DR) from one of my servers (PRODA)
so that I can add it as a linked server.
However, when I try to remove the remote server, I get the error:
There are still remote logins for the server 'DR'.
>From the PRODA server, ...more >>
conflict resolution Posted by Ravi Lobo at 4/3/2007 4:00:04 PM I have a merge replication setup.
I am using column level tracking
Subscribers are CLIENTS, so they are at the same level
Initially values in table t1 as
C1 -> 1
C2 -> 2
C3 -> 3
C4 -> 4
Sub1 updates,
C1->11
C2->22
Sub2 updates,
C2->222 (CONFLICT)
C3->33
1. sub1 sy...more >>
Replicating to MYSQL Posted by Fawzib Rojas at 4/3/2007 2:23:01 PM I have been trying to replicate from SQL2K to MySQL and I'm getting an
'Invalid Cursor State' error. After looking around for a solution I
found this old message (http://tinyurl.com/2mb5ln) saying it was a bug
in the distribution agent code and it would be fixed in future service
packs.
W...more >>
can't configure mirroring Posted by Panos Stavroulis. at 4/3/2007 9:40:06 AM Hi,
I've already configured a few databases from our server A to use mirroring
to our DR server. Now I've got a different primary server B and I am trying
to configure it so it mirrors to the same DR server. But I can't.
Is it supposed to work on the same port number as the first mirroring...more >>
merge replication compatibility issue Posted by jaylou at 4/3/2007 5:58:09 AM All,
I have a SQL2005 server that is running merge replication against SQL2000
boxes. One of my SQL2000 box needed to be replaced due to disk issues. I
scripted out my Subscription from my 2005 box and tried to reapply it after I
rebuilt my new 2000 box. When I run the script I get an err...more >>
Primary log shipping server down, manually to second Posted by Alex Delgado at 4/3/2007 5:58:02 AM Hi,
After reading several articles and newsgroups, I still face several doubts
about logshipping procedures.
We have three SQL 2000 servers, one primary (A), one secundary (B) and one
monitoring (C). There is a logshipping configured.
Between A and B there is a WAN.
I need to know ho...more >>
transactional replication with queued updates problem Posted by mike NO[at]SPAM martechcomputers.com at 4/2/2007 10:12:08 PM i have a publisher and distributor on 2000-sp3 and a subscriber on
2005-sp2 and am getting the following queue reader agent error when
updating data on the subscriber:
Server: A****, Database A**** : ODBC Error:Could not find stored
procedure ''upd.sp_MSsync_upd_tbl****_1''.
note "upd". T...more >>
Add Article(table) to Trans Repl - Move to Subscriber Posted by ThomBeaux at 4/2/2007 5:44:01 PM How to you add an Article (Table) to a Transaction Replication Publication,
and have it move to the Subscribers without having to re-generate the Whole
Snapshot?
What to I monitor to see this happen and how long to I wait to see it update?
--
Thanks and God Bless,
ThomBeaux...more >>
Error 21074: Subscriptions being made inactive Posted by Lavanya at 4/2/2007 6:06:45 AM Hi,
In my Single subscriber setup with Transactional Replication, i have
received this error on Distribution agent:
"The subscription(s) have been marked inactive and must be
reinitialized. NoSync subscriptions will need to be dropped and
recreated."
I know that this error occurs when th...more >>
Merge Replication Custom Conflict Resolver Posted by Jonathan Alvarez at 4/2/2007 12:00:00 AM Hi.
Anybody knows where can I find more info about "Merge replication custom
conflict resolver"?
I have readed the "Chapter 30" of "SQL Server 2000 Resource Kit" but it's
very little. I need more details.
Thanks and greetings.
...more >>
Avoid to replicate some columns Posted by CianoBer at 4/2/2007 12:00:00 AM I was just trying to replicate a table from a database to another. The 2
databases have the same schema, so every column of the 2 tables have the
same types. My problem is just I don't want to replicate all the
columns. If, for example, my tables have the columns A,B and C, I would
like to r...more >>
20598 MSrepl_errors information required Posted by Jack Griffith at 4/1/2007 1:16:23 PM I'd like to know how to know what replication stored procedure and parameters
to that is being run for a 20598 error I'm receiving.
in MSrepl_errors, for all these 20598 errors
error_text is: "The row was not found at the Subscriber when applying the
replicated command."
xact_seqno is:...more >>
How do I "suspend" merge replication while I extract data from central table? Posted by reefbreakbda NO[at]SPAM hotmail.com at 4/1/2007 1:43:10 AM Is there a standard practice to "hold" Merge replication so that the
data collected at the central server (in a remote sales order
application) can be periodically 'removed' to another part of the
system without clashing with ongoing replication from clients?
I'm experiencing my clients initia...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |