Post reply

Transaction log file Naming convention

  • July 6, 2009 at 10:49 pm

    #202089

    Hi Guys,

    I am trying to find the Transaction log file Naming convention in sql server 2005. I am using the file name for getting some info and later found that time stamp values on the log file is different from the actual backup time..

    Can someone help me out on this?

    Thanks in adv

    Manu

  • July 7, 2009 at 6:57 am

    #1021026

    I think its normally databasename_log.ldf.

    However, could you please be brief on that...

    Thanks & Regards,
    Sudeepta.
    http://twitter.com/skganguly

  • July 7, 2009 at 8:24 am

    #1021097

    I think he is asking about the naming conventions used for naming the transaction log backup files, but I could be wrong.

  • July 7, 2009 at 10:06 am

    #1021190

    I guess i was lil vaugue in my expln of the prob...

    Its like, i am trying to get the time stamp from the log backup file created by log shippin...

    and i found that the actual time stamp and time stamp on file are different...

    so, wanted to check if the timestamp on the filename is using any namin convention...

    or is it a bug?

    thanks

  • July 8, 2009 at 10:25 am

    #1021844

    The default naming for log backup files is:

    [dbname]_tlog_[yyyymmddhhmi].TRN

    For example:

    xyz_tlog_200907070515.TRN

    I think that the timestamp part of the filename is usually the time when the backup completed. If you are doing a verify pass on the backup, then the last modification timestamp on the file might be a minute or two later then the filename. (Well, that's the way it looks to me.)

    HTH.

    Edit: fixed formatting. Memo to Self: use Preview button more often.

  • July 9, 2009 at 1:31 am

    #1022182

    Better idea is to perform a RESTORE HEADERONLY FROM DISK = '...'

    With that you can find out all you'd ever want to know about the backup.

    Check http://msdn.microsoft.com/en-us/library/ms178536.aspx

    --------------------
    Colt 45 - the original point and click interface

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

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