Solved

Add a new site into a replicating SQL server system

Posted on 2011-03-02
5
183 Views
Last Modified: 2012-05-11
Hi Experts

I have a SQL server 2005 distribution server/publisher at my head office and 4 sites that subscribe to it, all merge subscriptions.

One of these sites has had a hard disc failure and no good backup. Not a huge problem as effectively I have a backup at the head office and the other 3 sites.

Can I restore a backup at the faulty site from a working site and just subscribe to my publisher again without causing any problems?

0
Comment
Question by:alexking
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 29

Expert Comment

by:Paul Jackson
ID: 35019314
Yes that will work, best to take the backup from the publisher.
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 35019322
It will work -when synching,sql server will create unique identifiers for the newly restored. db.
0
 

Author Comment

by:alexking
ID: 35019388
So if I delete the now non-functioning subscription from my publisher and create a new one I should be all fine?
Also because the 2nd disc in the server at the failed site has crashed with the database on it, when I run management studio, I can see the database listed but I cannot access it or do anything with it. Should I detach this defunct database and then just retore the backup?

Thanks for your speedy help!
0
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
ID: 35019441
Yes delete the subscription, detach the old database, restore from backup. Depending on your security model i.e. sql or windows, you may have to setup security for the database again.
Is the server in a different domain to the server where the backup is coming from? and if you use windows authentication the you will need to delete the logins from the database and add back in again.
0
 

Author Closing Comment

by:alexking
ID: 35122895
Sorry for the delay closing this, thanks for the re-assurance and it worked a charm!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration, of the HP EVA 4400 SAN Storage. The name , IP and the WWN ID’s used here are not the real ones. ABOUT THE STORAGE For most of you reading this, you …
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question