transaction log disk issue in replication enviornment

There is an issue with the disk thats hosting the transaction log on publication server.The database is set  for transactional replication.
The system folks wanted to remove the disk and present it back.
How do I bring back the replication when the log disks gets fixed.?
LVL 8
venk_rAsked:
Who is Participating?
 
geek_vjConnect With a Mentor Commented:
Here are the steps you can follow:

1. Take a full backup of the database (which is set for replication) and a tail log backup once the application is stopped.
2. Stop the replication on the publication server
3. Once the disk is attached back, check if the database is healthy (you have to run dbcc checkdb for that)
4. If the database is healthy, then proceed with enabling the replication - if everything is fine, this should go or you need to setup the replication again
5. If the database is not accessible/corrupt, restore from the full and tail log backups and enable/reinitiate the replication
0
 
Jim P.Commented:
venk_r,

Which version of SQL Server?

Are they destroying the volume?

Can you shut down the SQL Server?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Just stop replication before the disk tasks. Then when disk is ready to go, create new snapshot from replication and start replicate after snapshot finnish.

Good luck
0
 
venk_rAuthor Commented:
thanks
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.

All Courses

From novice to tech pro — start learning today.