1

I have SQL Server 2012 SP4, ten databases and log shipping.

One database 2.7TB

  • Ten data files and two log files

Log shipping configuration:

  • Transaction log backup job : 3 Min
  • Copy job : 1 Min
  • Restore job : 1 Min
  • Standby Mode, clicked Disconnect users...

A 50MB trn file take at 2 hours restored. The database is being 100% restored and remains. How do i solve this?

enter image description here enter image description here

Improve this question
8
  • How many virtual log files does this database have?
    – Tom V
    Dec 14, 2018 at 9:01
  • Changed between 5-30. I shrink log file sometimes.
    – Yunus UYANIK
    Dec 14, 2018 at 9:05
  • If you sometimes shrink the log file it means the log file grows sometimes. Depending on autogrouwth settings for the file that process can take much enough time. Looking at your trn-file's name I can suppose it can be the case because of some nightly scheduled tasks, which make the log file grow. Check it out.
    – Denis Rubashkin
    Dec 14, 2018 at 10:24
  • Yes, there is a shrink job and I disabled. Maybe index job growth the log file. Autogrowth by 1024MB. What should I do to speed up?
    – Yunus UYANIK
    Dec 14, 2018 at 11:28
  • Choose convenient size for your log-file so that it won't grow itself. The only way to speed up the log-file growing process is to place it on as fast as possible drive. So disable your shrink job (done) and look after your log shipping process for some time to make sure it was the mentioned case.
    – Denis Rubashkin
    Dec 14, 2018 at 12:54

1 Answer 1

Reset to default
0

I added sql service account to Perform volume maintenance tasks and disk slowness problem appeared on the server. The storage team replaced the disks with faster disks. Problem is solved.

enter image description hereenter image description here

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.