1

Looking at my SQL log shipping file names (following is an example)

Q:\Backups\LogShipping\MyAudit\MyAudit_20201027165400.trn

What date time format is the transaction log expressed in (local military time, UTC time)?

Improve this question

1 Answer 1

Reset to default
2

What date time format is the transaction log expressed

Yes, it is UTC time with the format dbname_YYYYMMDDHHMMSS (time is backup start time in 24 hours format). I think, following screenshot (copied from..) can help for easy validation.

Left side: Highlighted is Log Shipping backup name with UTC datetime
Right side: Date modified column indicating the time in +4 time-zone

enter image description here

Improve this answer
1
  • 1
    This is correct, UTC time. I also provided an answer to your linked question above, hopefully that's some help.
    – J.D.
    Oct 31, 2020 at 12:32

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.