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.
ThanksPls refer
http://forums.microsoft.com/MSDN/Sh...773170&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 w
as
> better in SQL 2000.
> Thanks
>
>
>
No comments:
Post a Comment