|
|
|
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 Replication Architecture/Design advise Posted by gresham NO[at]SPAM panix.com at 4/30/2005 12:00:00 AM I have been asked to set-up replication in the current two server
enviornment. My understanding is that Log-Shipping requires
the Enterprise version of Sql Server 2000 (Which they do not
have the budget for).
They have 70 Databases that have a total space of aprox 30gb.
They wan...more >>
Problem with push subscription where subscriber identified by IP not name Posted by Laurence Neville at 4/30/2005 12:00:00 AM I have set up six push subscriptions of the same publication on a wide area
network successfully, but am having a problem with the seventh one. I think
the problem is due to the fact that the subscription was set up using the
subscribing server's IP address rather than network name (there is c...more >>
Replication Error Posted by sean_ad at 4/29/2005 5:55:01 PM I have a copy of a database "db_A" called "db_copy". When I try to alter
tables in the database, it complains that it is being used for replication.
It is not being used for replication, but the database that it was copied
from is.
Is there anything I can do to allow us to alter this datab...more >>
Cannot drop database 'Tara' because it is being used for replicati Posted by bluefish at 4/29/2005 2:07:03 PM One of our critical databases that is part of a log shipping-like set up is
corrupt. This happened while doing a full DEb restore. DB was showing status
'Loading/Suspect' for about 5 hours. However, restore job has failed, and
nothing is attempting to restore it. I am unable to get get any ...more >>
8198 error Posted by ChrisR at 4/29/2005 1:51:07 PM sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Bo...more >>
Identity Error when replicating Posted by Roger Denison at 4/29/2005 10:06:05 AM I have some tables in a database that is tranactionally replicated to another
server.
Each table has a column which is the primary key as well as having the
Identity property set to Yes. The subscribing table has the same settings
for the corresponding column except that Indentity is set to ...more >>
DMO Anonymous Merge Pull Posted by Aubrey at 4/29/2005 7:04:02 AM I adapted Hilary's DMO Example, and have tried ReplCtrl\VB\ReplSamp.vbp ...
WHAT CODE DO I NEED to .Initialize .Run .Terminate the SQLMerge?
Subscription was created using Windows Synchronization Manager,
Administrator Account on WinXPPro Laptop. VB is running in MS Access XP
Runtime...more >>
SQL Server replication to Access Database Posted by Mr Statto at 4/29/2005 2:33:18 AM How can you make an Access database a subscriber to a replicated SQL Server
database? We plan to have a database on the server, and Access databases on
remote users PCs to access the data, but until I can work out how to
synchronise the data we might as well not bother...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Queue Reader fails to start on publisher Posted by batuka at 4/29/2005 12:00:00 AM We have configured transactional replication with queue updating
subscriptions. The publisher/distributor on serverA pushes a small db
publication to the subscriber on serverB. When both the publisher and
subscriber are continuously connected, modified data (on either server) is
replicated bac...more >>
firehosemode Posted by pardhi via SQLMonster.com at 4/29/2005 12:00:00 AM HI
I am trying to design merge replication.
step1:configure sqlservr1 as publisher and distributor and published pubs
database.
step2:from sqlserver2 i tried to pull the data using pull
subscription.everything works fine.
step3:again i decided to disabled publishing then start disabling s...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |