Post reply

Move logfile (ldf) while database is online

  • October 19, 2009 at 9:51 am

    #142580

    Hi There,

    Can I move the logfile (ldf) while my database is online and without interrupting any DB requests?

    Kind regards,

    Dave

  • October 19, 2009 at 9:57 am

    #1067726

    No. Moving any of the files of a database require that the database is offline or detached.

    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

  • October 19, 2009 at 10:10 am

    #1067733

    nope, downtime required, but you could script this and do it relatively quickly during off hours.

    I'd script it from the command line using osql, detach the db, then copy the files, then attach again.

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

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