What is the Transaction log backup date format, taken from Log shipping configuration?

Question

Post reply

What is the Transaction log backup date format, taken from Log shipping configuration?

Viewing 12 posts - 16 through 26 (of 26 total)

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

djjwu Old Hand Points: 316 More actions · Answer 1

sql 2005 logshipping tlog file date format is using GMT. The timestamp of the file still using server system time.

example

08/17/2009 04:00 PM 93,696 xxxxx_20090817210015.trn

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 2

thanks for all inputs, its really helped a lot.

finally, can I just ignore the date format for transaction backup file taken by the log shipping backup job? or need to change any settings?

the UTC date format is appearing only for the log shipping backup job trn files but not for the regular differential or log backups files.

Thank you

Ram

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 3

I wouldn't necessarily ignore the date - just understand that it is going to be unique based upon UTC time instead of local time. You still have to have a continuous log chain to be restored - and knowing how the filenames are generated will help identify a problem.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 4

Hi,

I went through the Log shipping configuration in BOL..but it no where mentioned that the transaction log files will have the UTC date format by design for log shipping.

Could you please any body take me to the link that says by design log shipping transaction files will have the UTC date format..

Thank you

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 5

Is the UTC date format for .trn files of a backup job of Log shipping is by design?

please clarify me

thanks

Ram

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 6

From Log shipping Backup job view history:

Selected row details:

Date8/24/2009 8:45:00 AM

LogJob History (LSBackup_Mydb)

Step ID1

Serversqlvs\ins1

Job NameLSBackup_Mydb

Step NameLog shipping backup log job step.

Duration00:00:00

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

2009-08-24 08:45:00.65Backing up transaction log. Primary Database: 'Mydb', Log Backup File: '\\sqlvs\Logshipping_Tlogs\Mydb_20090824154500.trn'

Is the UTC date format for .trn files of a backup job of Log shipping is by design?

please clarify me

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

rambilla4 (8/24/2009)
From Log shipping Backup job view history:
Selected row details:
Date8/24/2009 8:45:00 AM
LogJob History (LSBackup_Mydb)
Step ID1
Serversqlvs\ins1
Job NameLSBackup_Mydb
Step NameLog shipping backup log job step.
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
2009-08-24 08:45:00.65Backing up transaction log. Primary Database: 'Mydb', Log Backup File: '\\sqlvs\Logshipping_Tlogs\Mydb_20090824154500.trn'
Is the UTC date format for .trn files of a backup job of Log shipping is by design?
please clarify me

Question, it is what it is, why is it so important to know if this is by design? From what I can see, it is. If it is that important, could one of the MVP's on SSC ping some for some clarification on this? I wouldn't know who to ask plus I'm not an MVP.

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 8

thank you very much,

What is your .trn file, which is generated by Log shipping backup job?

Question, it is what it is, why is it so important to know if this is by design?

Because I want to know it is same for every body or not. If it is not why I'm getting the UTC date format? that's what I want to make sure from the forum members.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

rambilla4 (8/24/2009)
thank you very much,
What is your .trn file, which is generated by Log shipping backup job?
Question, it is what it is, why is it so important to know if this is by design?
Because I want to know it is same for every body or not. If it is not why I'm getting the UTC date format? that's what I want to make sure from the forum members.

If I was using log shipping, I'd be more than happy to tell you. we don't have log shipping setup here. All my knowledge is theory only, but I have been reading up on it as we may be looking at using it in the near future. The more I know, the better when it is time to set it up.

rambilla4 SSCrazy Eights Points: 8715 More actions · Answer 10

Any body implemented/using Log shipping please provide me the below details:

What is the date format for your .trn file, which is generated by Log shipping backup job? Just post the information from Log the shipping Backup job view history

thanks

Mani-584606 SSChampion Points: 11788 More actions · Answer 11

Go through this link..

http://www.windows-tech.info/15/2b775367de544d88.php#

which says, UTC time stamp is by design for Log shipping .trn files. But looks like there is no documentation for this on BOL...weird:hehe::hehe:

gregtm SSC Eights! Points: 836 More actions · Answer 12

It there a way to change it from UTC? or how about using SP_HELP_LOG_SHIPPING_MONITOR to convert the time in the results?