Post reply

removing LDF2 from the database

  • May 22, 2013 at 8:28 am

    #294318

    Hi,

    What is best procedure to remove a log file from the database on Production database.

    Note: we have added one extra log file to Production database due to log filefull issue.Now we need to delete that log file.

  • May 22, 2013 at 8:47 am

    #1617480

    Wait until no portion of the active log is within that file (DBCC LogInfo). Once that's the case, ALTER DATABASE and drop the file.

    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

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

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