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?

  • 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.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events