TransWikia.com

In what order does sqllogship.exe process groups of log files?

Database Administrators Asked by Scott Magnan on December 21, 2021

In what order does sqllogship.exe processes groups of log files based solely on filename order or does it does it do it based on file timestamp primary sort then filename secondary sort?

It appears to handles things in filename order when all log files have the same timestamp.

One Answer

It appears to handles things in filename order

Yes and no. Yes the files are sorted in filename order which generally happens to be the same as the restore order, thus it looks like it goes in order of filename. No, because the files may be tested to see if they contain the log records for the next restore, which means their name could be slightly different and still process. Note that the filename sort is case insensitive and that filenames do matter.

Answered by Sean Gallardy - Mostly Retired on December 21, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP