Need to restore the database without breaking replication

Hello Experts,

Is there any way where ,we can restore the old backup to the publisher without disturbing the existing replication.
After restore, it should start the snapsnot and should start publishing the articles to subscriber.

And publisher is of 220 gb and only 20 articles will be published.But all 20 articles has high volume of data ¬ 1 billions records.It takes 6 hours to set up the replication.

Is there any faster way to cut down the timings?
LVL 5
VIVEKANANDHAN_PERIASAMYAsked:
Who is Participating?
 
Racim BOUDJAKDJIConnect With a Mentor Database Architect - Dba - Data ScientistCommented:
Is there any way where ,we can restore the old backup to the publisher without disturbing the existing replication.
If you overwrite the existing published container, you better reinitialize your replication by dropping and recreating it.

Is there any faster way to cut down the timings?
I am afraid not but if you tell us why you need to do the restore, we may suggest a different course of action.

Hope this helps.
0
 
VIVEKANANDHAN_PERIASAMYAuthor Commented:
It's because, we have static backup ,reload the backup and reload with max value of record and do the performance testing with set of value ,record the values.
reload the db again and increase more records and record the values.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
If this is 2005 and above, I would suggest setting up a database mirroring in parallel with replication, build a snapshot then point out temporarily reads on the snapshot in the publisher.  That will give you time to reset your replication.  

Hope this helps.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
VIVEKANANDHAN_PERIASAMYAuthor Commented:
If this is 2005 and above, I would suggest setting up a database mirroring in parallel with replication, build a snapshot then point out temporarily reads on the snapshot in the publisher.  That will give you time to reset your replication

I didn't get this point ,can you please explain me more briefly.

If i set up the mirroring how will it help during restore.Any way mirroring will get broken right.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
I didn't get this point ,can you please explain me more briefly.
Means you can maintain remove the replication while keeping the data being synchronized on the mirror available for reads and refreshed periodically.

If i set up the mirroring how will it help during restore
You mirror on a database copy on the mirror, drop the publication, drop the replicated DB, restore the DB and recreate the replication.  The data will be available on the mirrored copy on readonly and can even be refreshed periodically.

You asked for a way to minimize downtime.
0
 
VIVEKANANDHAN_PERIASAMYAuthor Commented:
I need to understand.
0
 
VIVEKANANDHAN_PERIASAMYAuthor Commented:
Since answer not practically appliable.I rating as C
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.