|
Still Error 18483
Sorry - I didn't see this post and have applied to your
original thread.
Rgds,
Paul Ibison ...
Tue, 30 Nov 2004 05:39:21 -0800
|
Creating custom merge profile
You can also in the Create Publication Wizard, select
Yes, minimize the amount of data on the Optimize
Synchronization page (@keep_partition_changes = true),
and consider if column-level tracking is appropriate for
the business needs.
The timeout parameterss are usually adjusted only when
timeouts are ...
Tue, 30 Nov 2004 04:14:37 -0800
|
Pull subscription
Hi,
I'm trying to create a pull subscription but it fails. I
would like to synchronize data between my laptop (remote
or in network) and our SQL Server.
I managed to create a push subscription replicating every
hour but it would be better to have a pull subscription.
I always get an error saying that t ...
Tue, 30 Nov 2004 02:55:00 -0800
|
Restoring replication
I have a problem that needs tip: Our main replica server need to be restored.
It has been the main server within a network using merge replications between
around 10 servers with publications and push/pull subscriptions. Now listen
the server was stolen and I need to restore (I got the all the *.mdf files on ...
Tue, 30 Nov 2004 02:47:03 -0800
|
Creating custom merge profile
Hi,
I am trying to create custom merge profile for merge replication
between SLQ2000 and MSDE2000. The link between the two is usually 33,6
kb/s. I have checked parameters for 'Slow link profile', but there is
only one parameter different comparing to the default profile
(UploadGenerationsPerBatch).
Can s ...
30 Nov 2004 02:30:09 -0800
|
Trigger and replication
I have set up the transactional replication with Qued option ..
I have a trigger on one of the table which inserts the data in another
tables after insert /update activity happens . I have set up the trigger
with Not for replication
but still the trigger is fired twice without any interval .. and making ...
Tue, 30 Nov 2004 11:37:52 +0530
|
Trigger and replication
I have set up the transactional replication with Qued option ..
I have a trigger on one of the table which inserts the data in another
tables after insert /update activity happens . I have set up the trigger
with Not for replication
but still the trigger is fired twice without any interval .. and making the
da ...
Tue, 30 Nov 2004 11:33:34 +0530
|
Can't view merge agent properties
In Enterprise Manager (EM), if you go to: [Replication Monitor -> Agents ->
Merge Agents] you'll see a list of Merge Agents to the right.
I'd like to be able to select one of the items, right-click, and select
"Agent Properties".
When I do this, I get a dialog box that appears. The title of the dialog is
...
Mon, 29 Nov 2004 23:48:37 -0500
|
defaults on columns
I have a transactional queued replication. Occasionally the servers become
disconnected. When they reconnect, the replication restarts but defaults on
the columns seems to be lost on the subscriber. Is there some reason why the
default values are being lost and is there any way to fix this?
Thanks! ...
Mon, 29 Nov 2004 18:41:02 -0800
|
GPRS replication troubles : 28562
Hello:
I get this number of errors when I'm trying to merge replicate over GPRS. It
occurs only some times:
error 80072EE7 with native 28562
error 80072EFD with native 28562
and after those errors I get 80004005 with 28557.
What about are these errors? why the database gets unstable? how can I avoid
...
Mon, 29 Nov 2004 12:41:28 +0100
|
log shipping restore failing
hi,
I wanted to test log shipping between 2 sql servers 2000 developer editions
(each of different computer).
so i did the following steps:
1. I wanted to make the the database on both servers equal:
I deleted the log of the database from both server (primary and sencodary),
by switching the recovery ...
Mon, 29 Nov 2004 03:17:04 -0800
|
SQL 2000 Standard Edition : Log Shipping copy problem..
I am not too clear on the question, but if the full
database backup has been transferred and restored to the
standby server and log shipping is set up, there is no
further requirement to transfer the database backups. If
it is not yet set up, then if you establish a time when
users can't access the syste ...
Mon, 29 Nov 2004 02:54:28 -0800
|
Recreate snapshot manually after changes?
For an existing article this is not necessary - just run
the merge agent. If you want to add a new article then it
is needed before synchronizing.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
...
Mon, 29 Nov 2004 02:14:44 -0800
|
Problem in Merge Replication
I am Getting Timeout Problem when the meta data CleanUp Process Related to
Merge Replication is running
I just want to know
a) What event triggers this job to run.
b) What does this job does.
c) What happens if the job does not run
d) whether i can modify the job to run only on Sundays when there is no
...
Mon, 29 Nov 2004 02:13:02 -0800
|
Problem in Merge Replication
I am getting TimeOut Problem when Meta Data Cleanup Process related to Merge
Replication is running.
I just want to know
1. whether I can modify the job to run only on sundays and not on production.
2. What happens If these Jobs Doesnot Run
3. What Does these Jobs Run
4. What Event triggers this job to run ...
Mon, 29 Nov 2004 02:09:05 -0800
|