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

Restore Replicated DB in SQL Server 2008 R2

Hi Team,

SQL DB corrupted i want to rename this db and restore from backup.
But this DB is part of Transactional Replication.
Please suggest.
0
Vijay
Asked:
Vijay
  • 3
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
  1. Stop the Replication
  2. Rename the Database
  3. Restore the Database from the Backup
  4. Recreate the Replication
0
 
VijayAuthor Commented:
Is it safe to change SQL DATABASE mode from SIMPLE to  FULL then FULL to SIMPLE while database is part of transactional replication?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Why do you want to change the database recovery model?
Anyway, Transactional Replication requires full recovery model so you can only change the recovery model after you stop the Replication.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Solution provided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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