We had a two-site system go badly wrong as a result of something. The net
result of this was that the publisher had to be completely reformatted and
reinstalled. The server has, as a result of this, been given a different
name (went from being a named instance to not being one).
Currently the publisher doesn't know it's a replicating system.
Is there any way to join these two together so that they just start
from where they left off, or will I have to re-do all the replication
from scratch by various SELECT INTOs to get the data across, then
pushing out fresh subscriptions?
Thanks,
Jim
--
Find me at http://www.ursaMinorBeta.co.uk
JediGeeks http://www.jedigeeks.com
"There's no 'I' in team, but there is a 'me' if you jumble
the letters up a bit." - Dr. House. 2  1307 
You might get a better response in
microsoft.publi c.sqlserver.rep lication.
Simon
In article <11************ *********@g14g2 000cwa.googlegr oups.com>, Simon Hayes wrote: You might get a better response in
microsoft.publi c.sqlserver.rep lication.
Thanks.
Jim
--
Find me at http://www.ursaMinorBeta.co.uk
JediGeeks http://www.jedigeeks.com
"There's no 'I' in team, but there is a 'me' if you jumble
the letters up a bit." - Dr. House. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Nathan Simpson |
last post by:
Hi,
We have one domain with a mixture of NT PDC's one Win2K DC (which was the
first installed) and 4 Windows 2003 DC's.
I created our sites as per MS documentation and created the subnets that
match each site. I moved each server into its own site. I then create the
Inter-site transport with IP. I create one call "All Sites" and copied all
sites into it.
|
by: Joe Powell |
last post by:
We are migrating from SCO with 8i to SuSe SLES 8 with 9iR2 on our
Compaq i586 backup server "BKUP". This has already been done on our
development server "DEV" and production server "PROD". The RDBMS and
database on DEV, BKUP, and PROD are all named the same and stored
within one (~48Gb) filesystem. Besides the HOST name in listener.ora,
I am not aware of any other differences between the RDBMS or databases
on these servers.
Last week,...
|
by: Osmin Castillo |
last post by:
Hi guys, I need your help with this:
I have two big databases in two different servers, each database
it's different too and I need to replicate each one to a single
mysql slave server.
I need this:
MasterA ---> SlaveC <-- MasterB
|
by: Brian E. Seppanen |
last post by:
I have a large number of tables in a database, and I'm looking at
replicating only 5 of those 4000+ tables to about 5-7 other hosts.
The primary server runs 4.0.15 and would replicate to 3.23 hosts. Is
this possible. Will 3.23.58 be able to get databases updates via
replication from 4.0.15?
Any assistance, insights, gotcha's appreciated.
Thanks,
|
by: Patrick Johnson |
last post by:
Hello,
I'm not sure where to start with this. I have 3 MSSQL servers. Server
A publishes a database to B and C. The publication is set up as
transactional, immediate updating with queued failover. There is a
'push' subscription from A to B and C. MSSQL 2K SP3. Win2K.
This has been working perfectly for several months.
Recently I tried to add a column to one of the tables using
| | |
by: almousawi |
last post by:
I am working on a DB2 replication program that used to work. I ran the
"warm" capture program to get a cold start and I am running the apply
program, but, the apply does not replicate the data. I update a test
table and I see that the CD table gets new rows. But the apply program
does not seem to be doing anything .. I see the asnapply is running,but
not doing anything:
2005-07-31-02:18:03 ASN1045I: The Apply program was started using...
|
by: ceadtinneh |
last post by:
We're running merge replication between to SQL Server 2000 servers. The
application isn't very high volume the setup is pretty vanilla (ie no
filters, etc).
We have a push subscription set up and we seem to replicating data
between publisher and subscriber, with one exception:
When we update a particular int column at the publisher, the update
won't propogate to the subscriber. Updating the same column at the
subscriber does result...
|
by: Radek |
last post by:
Hi
I'm in need of creating reporting database. What I have to do it is to
replicate only half of tables to next database so reports could query
only that second database. Unfortunately there is too many inserts in
existing database so simple master/slave solution won't give me much. I
was wondering if there is a way to replicate just few tables? Can I use
for it mysql replication or do I have to create manually scripts to do
that?
I...
|
by: aswath |
last post by:
hi dere,
i have a question.
i have an array with replicating values.... al i want to do is
delete all replicating values and store the result in another array.
eg.,
String a={1,2,3,3};
String b;
b should be 1.2.3only........not 1,2,3,3
thanks in advance,
regards,
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
