Home > Backup and Restore > Restore the Production Database which is part of replication

Restore the Production Database which is part of replication


Issue Description: One week back we got an urgent request to restore the database from a specific point of time because someone from an application team accidently deleted some rows from the database which stopped 1400 hundred employees from accessing building facilities. They wanted to restore the database from a specific point of time, but concern here is that database being restored  is part of the replication as per the high availability scenario. I had to restore the primary database without destroying the Replication settings.  Here I have mentioned the step to restore the database while preserving the replication settings.

 

We are maintaining daily full backup and every 15 minute Transactional log backup in a database Full recovery model. The issue happened at 7 40. so we have a full backup from 7 and two transactional log backups at 7.15 and 7.30. We can restore the database up to 7.30 and here we have to use Preserve the replication settings option during restoration so replication settings are not destroyed.

 

Advertisements
Categories: Backup and Restore
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: