Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When SQL Server log shipping generates transaction logs through a command like

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqllogship.exe" -Backup 60CD93F9-CFC2-4A84-8B06-3AD8DEADBEEF -server DummyServer

The file that gets generated looks like

2010-08-20 15:02:29.12  The backup operation was successful. Primary Database: 'Dummy', Log Backup File: 'd:\test\Dummy_20100820220229.trn'

The date part of the file ("20100820220229") is in GMT time, not local time.

Any way to make it local time? That's better for correlating with logs etc. Thanks!

share|improve this question

1 Answer 1

No. GMT is used in case you are log shipping between timezones.

share|improve this answer
    
Thanks mrdenny. I get that's a sensible default, but isn't that customizable? After all, log shipping doesn't rely on file names date/time to consume them, correct? thanks! –  Ariel Aug 21 '10 at 13:03
    
I don't believe that it is, as normally a person wouldn't ever look at the file names for any reason. I believe that it does look at the date and time in the file as you can tell log shipping to delay import by X amount of time so it would need to know what time the files were created. –  mrdenny Aug 22 '10 at 6:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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