Home Forums SQL Server 2008 SQL Server 2008 Administration How to manage log space issue, when you have more than 1 log file for a particular database? RE: How to manage log space issue, when you have more than 1 log file for a particular database?

  • January 20, 2013 at 5:21 pm

    #1579062

    SQLRNNR (1/18/2013)

    Somebody probably created the second file as a spillover due to the space issues.

    If the drive where the first log file was created is out of space, I would migrate to the second file by emptying the first file and then delete that first file. Just use the second file on the drive that has adequate free space.

    Is there any impact on log shipping by doing this?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience