March 14, 2007 at 11:35 am
Has anyone seen this behavior in SQL 2005? We are running log shipping and the transaction log backup files created through the log shipping executable are timestamped with a UTC time. (Job step created by log shipping wizard runs ""C:\Program Files\Microsoft SQL Server\...\sqllogship.exe" -Backup [...some id...] -server [server name]"). So files created at 6am will be named "[backup log name]_200703141100.trn."
However, any transaction log backups or database backups created as normal maintenance plans will have the local time in the file name. So files created at 6am will be named "[backup log name]_200703140600.trn."
Is there some setting I missed to say whether to use UTC time? Saw this behavior before DST change and before DST patch applied to server. This is more nuisance than problem, but am curious about how this is working...
June 23, 2007 at 2:18 am
I'm experiencing the same problem (see my post in the MSDN forum; posted a few minutes before I saw your thread here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1773170&SiteID=1)
Have you found any explanation for this?
Regards,
André
January 2, 2008 at 1:35 pm
Today I set up 2005 log shipping for the first time and I have the same behavior.
In addition, although my copies and restores seem to be working, the secondary server is alerting that the 'time since last restore' is greater than my 45 min threshold. But that is not true. I am wondering if that incorrect time in the backup file name has something to do with that.
July 3, 2008 at 7:35 am
what is the difference b\w transactional log back up&tansactional log back upin log shipping & transactional replication
July 3, 2008 at 4:34 pm
This is not the correct thread to ask this question. If you can't find a thread about what you want to ask, open a new one.
I didn't understand the question either...
July 5, 2008 at 11:00 am
The log shipping tlog filename has the UTC time embedded in it and uses this value for propagating tlog files to the secondary. UTC time is used in case the primary server and secondary server(s) are in a different time zone.
I think, this is by design.
July 5, 2008 at 6:12 pm
Please refer this thread. As mentioned by Bala it is by design..
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1779257&SiteID=1
[font="Verdana"]- Deepak[/font]
August 25, 2009 at 10:43 pm
If Log shipping backups takes UTC time for log backups as designed, then why there is no uniformity across all log shipping setups as some of the log shipping scenarios takes current data and time for naming log backup files.
August 25, 2009 at 11:35 pm
Hi Mels,
Please see my post here http://www.sqlservercentral.com/Forums/Topic771695-146-1.aspx.
I'm also discussing the same from last 4 days and every body saying UTC time stamp is by design for log shipping .trn files
But nowhere mentioned about this in BOL:-D:-D
August 25, 2009 at 11:59 pm
rambilla4 (8/25/2009)
Hi Mels,Please see my post here http://www.sqlservercentral.com/Forums/Topic771695-146-1.aspx.
I'm also discussing the same from last 4 days and every body saying UTC time stamp is by design for log shipping .trn files
But nowhere mentioned about this in BOL:-D:-D
Just because it isn't in BOL doesn't mean that it isn't designed that way. It just means the documentation for it is lacking. There is a difference.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply