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)?
asked Oct 27, 2020 at 18:24
Add a comment
|
1 Answer
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
answered Oct 27, 2020 at 18:50
-
1This is correct, UTC time. I also provided an answer to your linked question above, hopefully that's some help.– J.D.Commented Oct 31, 2020 at 12:32