What is log backup date format represents?

Question

Post reply

What is log backup date format represents?

rambilla4

SSCrazy Eights

Points: 8715
More actions
July 28, 2009 at 11:59 am

#134334

Hi,
I have configured log shipping in sql server 2005. Could you please tell me what this log shiping log backup date format is?
Below is the log backup taken at 4:00 PM on 07/24/09.
Test_20090724230001.trn
But I did not understand where its representing 4:00 PM?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sqlstad SSCrazy Points: 2484 More actions · Answer 1

This the format:

Test_20090724230001.trn

Test_yyyymmddhhMMnr.trn

yyyy: year

mm: month

dd: day

hh: hour

MM: minute

nr: first number in that timeframe.

So the log backup should have started on 23:00 that evening.

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 2

No...I'm sure that this log backup Test_20090724230001.trn occurred at 4:00 PM. As you saying it occurred 23.00 but not.

It should have Test_20090724160001.trn as per the date format you are saying...

I'm confused!!!!!!

ps. One Orange Chip Points: 29422 More actions · Answer 3

I think what sanderstad wrote is correct. I just verified that by creating a maintainence plan. Can u check if the server time is different from your local system time?

Pradeep Singh

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 4

hello PS,

I have configured this log shipping in sql server 2005 using the Log shipping wizard and the server timings are also correct. Could you please tell me the exact date format for the transaction log backup taken through the back job created by the Log shipping configuration wizard.

thanks

ps. One Orange Chip Points: 29422 More actions · Answer 5

I did setup log shipping and following were some of the files generated.

My db name is pubs_2000. Date on my machine while i tested this was 29th dec 2009. I also changed the time after first two log files and again after 3rd log backup.

pubs_2000_20091229073343.trn

pubs_2000_20091229073404.trn

pubs_2000_20091229113422.trn

pubs_2000_20091229123441.trn

When the time was 1 PM, the first two digits showed 07, when i changed the time to 5PM, the first two digits changed to 11, again i increased the time by an hour and it changed to 12... I think there is some corelation but cant seem to find out exact corelation.

This should not bother you much anyways...

Pradeep Singh