Post reply

Separating MDF and LDF

  • October 9, 2007 at 1:47 pm

    #119030

    I am having a large amount of disk installed and want the move the log files to this new area. How do I go about doing this? :unsure: I have less than 25 databases so a strictly manual process is fine.

  • October 9, 2007 at 2:25 pm

    #740528

    1) Detach the userDB

    2) Copy LDF over to new disk subsystem (i.e. D:\MyDB.LDF -> E:\MyDB.LDF)

    3) Reattach the userDB using the new LDF (i.e. E:\MyDB.LDF)

    4) Verify userDB

    5) Delete the old LDF (i.e. D:\MyDB.LDF)

    Tommy

    Follow @sqlscribe

  • October 9, 2007 at 2:44 pm

    #740541

    Thanks, that what I needed.

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

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