all groups > sql server replication > october 2004 > threads for october 29 - 31, 2004
Filter by week: 1 2 3 4 5
Replication Error
Posted by Shash Goyal at 10/31/2004 5:46:56 PM
I have three questions??
1. I have a Sql server instance running without any name, it just has a
default name (local), when i try to go configure replication its says that
replication does not support (local) name. This server is in production
right now. And it will be hard to shut it down. ... more >>
after install sqlsp3 in sqlserver200 , repliction is not use
Posted by ´ý at 10/31/2004 3:02:38 PM
replication performance
Posted by Hassan at 10/30/2004 10:27:57 PM
We currently use log shipping as a means of reporting for users to query off
of on the secondary hence eliminating ad hoc querying on the live OLTP
server
Problem with log shipping is obvious..Users are kicked off when logs are
being restored.
So if we do use replication for each and every ... more >>
Linked Server Replication Publisher
Posted by Phil Willett (DBx) at 10/29/2004 5:31:01 PM
Is it possible to configure a linked server to be a replication publisher in
sql server 2000. I have a progress v9.1 database that is configured to act as
a linked server that I would like to make a publisher and then use a sql
server 2000 subscriber. Thanks!... more >>
Agent Scheduling Confusion....
Posted by Will Gillen at 10/29/2004 2:19:18 PM
I'm a little confused.
I've been working on setting up one snapshot publication for one DB, and one
"one-way" transactional publication for another DB (both on the same
server).
My three "client" subscribers are running MSDE 2000 SP3, and they are
subscribing to these to Publishers.
As I... more >>
Log Reader problem
Posted by Roger at 10/29/2004 12:35:44 PM
Hello all,
I am seeing a rather odd replication issue, thats new to me and I was
wondering of anyone could provide insight on how to resolve it.
I have several SQL servers (SQL2k w/ all patches and SP) replicating
several databases via a transactional replication. There have been no
... more >>
truncate log: error 4215
Posted by tohas NO[at]SPAM freenet.de at 10/29/2004 11:29:22 AM
HI NG,
on a testserver mssql2k I have one publication
with NO subscribers
backup LOG ..
fails:
The log was not truncated because records at the beginning of the log
are pending replication. Ensure the Log Reader Agent is running or use
sp_repldone to mark transactions as distributed.
... more >>
Invalid column name 'rowguiedcol' - error number 207
Posted by Robert A. DiFrancesco at 10/29/2004 10:55:38 AM
"The process could not deliver the snapshot to the Subscriber"
I added a new database to the same server as the publisher and distributor.
The error ocurred when pushing a new subscription to it.
I did indicate that the subscriber already has the schema and data.
Any ideas for correcting?... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Investigating what makes my log file grow and grow and grow
Posted by Roger Denison at 10/29/2004 9:13:53 AM
I need to learn the steps to investigate which
transactions are not getting replicated, thus causing my
log file to grow. I periodically check the dbs I
administer and wait until after hours to force
replacation done using sp_ReplDone, followed by a backup
and shrink, for those dbs with e... more >>
Adding columns during replication
Posted by Abdul Rauf at 10/29/2004 7:51:05 AM
Is there any way to add columns to the database and not have to stop
replication.
I have one publisher with many subscribers and I don't want to delete all
the subscriptions to add columns to my publisher.
If this is not the correct way to add columns could you please explain how I
shoul... more >>
How to configure Logshipping across the two forests
Posted by Rajendra at 10/29/2004 5:45:06 AM
Hi,
I have configured Log shipping in my organisation which has two forests. One
forest has primary server and monitor server while the other forest has
secondary server. While configuring the Log shipping, read only database was
created successfully on the secondary server. Primary server ... more >>
Backing up a Merge Replication Subscriber database
Posted by Jonathan Ainsworth at 10/29/2004 3:05:03 AM
Environment:
Central SQL 2000 db (with SP3a), employing 3 Merge Publications with column
level tracking
240 distributed/disconnected subscribers using pull subscriptions running
MSDE 2000
We're having a high volume of suspect databases appearing. Causes are varied
but the majority are tor... more >>
|