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

  • How many virtual log files does this database have? – Tom V Dec 14 '18 at 9:01
  • Changed between 5-30. I shrink log file sometimes. – Yunus UYANIK Dec 14 '18 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 '18 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 '18 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 '18 at 12:54
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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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