• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

Add a new site into a replicating SQL server system

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
alexking
Asked:
alexking
  • 2
  • 2
1 Solution
 
Paul JacksonCommented:
Yes that will work, best to take the backup from the publisher.
0
 
NormanMainaCommented:
It will work -when synching,sql server will create unique identifiers for the newly restored. db.
0
 
alexkingAuthor Commented:
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
 
Paul JacksonCommented:
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
 
alexkingAuthor Commented:
Sorry for the delay closing this, thanks for the re-assurance and it worked a charm!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now