Post reply

Backup multiple transaction log files

  • March 19, 2010 at 1:30 am

    #220020

    Hi Experts,

    I have some doubts regarding the multiple log files.

    When we backup the log file will it create the backup of entire txion log file in different drives?

    What is the use of multiple log files other than managing space?

    Since txion log file is sequential i think it wil fill only one after the other.

    Wat if one disk fails and have another log intact(old txion log).Can we take a log backup in this case?

    TIA

  • March 19, 2010 at 3:07 am

    #1136532

    Ratheesh.K.Nair (3/19/2010)

    When we backup the log file will it create the backup of entire txion log file in different drives?

    It'll backup the inactive log records, regardless of what file they're in

    What is the use of multiple log files other than managing space?

    None.

    Since txion log file is sequential i think it wil fill only one after the other.

    Correct

    Wat if one disk fails and have another log intact(old txion log).Can we take a log backup in this case?

    Depends. If the file on the failed disk didn't have any portion of the active or inactive log, maybe. If the log on the failed drive had log records that needed to be backed up, no.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 19, 2010 at 3:21 am

    #1136540

    Thanks a lot Gail

Viewing 3 posts - 1 through 2 (of 2 total)

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