Wednesday, March 28, 2012

Log shipping TLog dump naming covention

The Tlog dump as part of Log shipping has got me wondering on how the time
portion of the file name is done. So right now I have a file name called
DBName_20071109204000.trn that was taken at 12:40pm on 11/9/2007. Just
looking at the file, how can you tell the time ? I am using SQL 2005. It was
better in SQL 2000.
Thanks
Pls refer
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1773170&SiteID=1
it uses UTC timing convention I believe !
Thanxx
Deepak
"Hassan" wrote:

> The Tlog dump as part of Log shipping has got me wondering on how the time
> portion of the file name is done. So right now I have a file name called
> DBName_20071109204000.trn that was taken at 12:40pm on 11/9/2007. Just
> looking at the file, how can you tell the time ? I am using SQL 2005. It was
> better in SQL 2000.
> Thanks
>
>
>

No comments:

Post a Comment