473,216 Members | 2,186 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,216 software developers and data experts.

After a corrupted publisher

Ron
Hi All,

I am fairly new to MS SQL Replication. I have two servers one is setup
as the publisher and the other is setup as both the subscriber and the
distributor.

Due to server reboots, the publicher DB became corrupted therefore we
pointed all activity to the subscriber DB. Now we would like to bring
back the publisher online, but we do not have a backup.

My Question is, can we restore the publisher DB from the backup of the
subscriber and reinstate replication? if yes could someone please
explain the process as I am new to SQL and replication.

Question two, someone metioned while re-establishing replication I can
regenerate the DB by doing a snapshot. How can I do that on the
publisher.

If you have any other method that will help bring back the publisher
and copy the updated data from the suscriber to the publisher and
re-instate replication that would be great.

PS: the reason why we know the publisher is corrupted is due to a DBCC
CHECKDB(XXX) which gave us a lot of errors.

Thank you much,

Ron

Oct 4 '06 #1
0 1478

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Seb LM | last post by:
Hello, I'd like to define a publisher policy which covers many versions of assembly from which the "major.minor version" are different but it's not possible to make a such publisher policy. So...
1
by: excession | last post by:
Hey I'm trying to use an XML Custom publisher, but it doesn't look like the custom publisher class is being called.. I think it is a problem in config. The name of the app is appName.exe...
1
by: tgru | last post by:
I have taken over a transactional replication setup that is being used for fault tolerance (I know, I know...). The scenario I am concerned with is where the publisher goes down due to failure,...
0
by: Niyazi | last post by:
Hi, I am having problem with TreeView After Selected. My TreeView Nodes looks as: Publisher UK Publisher US Publisher Authors UK Authors
3
by: accesstribe | last post by:
Hello, I have DB located on network, and network cable was cut off accidently few days ago... now its fixed, but I can't add new records to the DB with forms... The error I get is this (when...
9
by: Jamie | last post by:
I am receiving an Invalid ViewState error after posting back to the same page twice. Consistently the error occurs after the second postback and not after the first. I have looked into creating...
0
by: Rich | last post by:
Hello, I have a simple console app for deploying an MS Access app. Recently, I started having a problem publishing the app to my webserver with the publisher feature of VS2005 when I do an...
0
by: joe1977 | last post by:
my macro in Publisher changes "123" into "321" (example) but I can't be able to run it. This is how far I get throught with PHP & Publisher: <? $pub = new COM('publisher.application') or...
1
by: =?Utf-8?B?U2NvdHQ=?= | last post by:
Publisher policies sound just like what I need but I just can't get these things to work. There are several good kb articles that seem to show exactly what needs to be done.... Here is my...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.