Archived Months
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


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 >>



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 >>


DevelopmentNow Blog