Restore db with StandBY taking a lot time

• v_nikonor

  SSC-Addicted

  Points: 448

  More actions

  December 20, 2019 at 2:59 pm

  #3709593

  SQl server 2017 CU16 ., the size of db about 600 Gb + 140 Gb log, the db has table-in -memory

  We have process to automatically restore log from prod backup to DEV server.

  The process restore to stanby take  a lot of time ,more 1 hours, if  I run t restore without standby It will take less 1 -2minutes.

  Also , I turned on flag 1254. not helped

  What is problem? Have idea?

   

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  December 21, 2019 at 3:10 pm

  #3709794

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

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