Initialize VLDB replication from Subscriber database backup

• S_DBA

  Old Hand

  Points: 382

  More actions

  January 3, 2020 at 10:19 pm

  #3712268

  Hello,

  We currently have Publisher database A, Distributor database D, Subscriber database Sub1 setup as transactional push replication. Since the Publisher database A is very large (2Tb), I would like to know if there is any way we can use sub1 snapshot using pure array storage and create a new subscriber sub2 for the existing replication?

  Basically, i would like to take advantage of pure storage snapshots and restores to reduce the backup and restore process.

  The process in mind is:

  1. Take snapshot of existing sub1 database volume
  2. Restore the snapshot on new server as sub2 to retain schema and data. This takes 1-2 seconds.
  3. Initialize the subscription to sub2 such that sub1 and sub2 are in sync with publisher database A.

  We are doing this to increase the number of subscription databases and avoid long backup and restore times. I went through articles where they mention initialize through LSN but that is not an option if we are taking backups of subscriber database.

  Also, note that I want to initialize the replication without snapshot from subscriber DB backup. This is because the subscriber db has subscription from different publishers and not just publisher database A.

  Any ideas?

  • This topic was modified 5 years, 8 months ago by S_DBA. Reason: More explaination

• Site Owners

  SSC Guru

  Points: 80381

  More actions

  January 4, 2020 at 11:10 pm

  #3712416

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• S_DBA

  Old Hand

  Points: 382

  More actions

  January 7, 2020 at 12:05 am

  #3713013

  Guys, please share your thoughts. Really appreciate.