Post reply

.MDF, .LDF file moving

  • September 12, 2008 at 1:18 am

    #382627

    Hi Every body,

    Some speace issue,...

    I am planning to move .MDF, .LDF files to move to c:\ dirve to E:\ drive

    How can i move

    could you please any body explaine the good approach

    reallay greate thanks

  • September 12, 2008 at 1:46 am

    #870797

    Two options.

    1) Detach the database, move the files, reattach the database.

    2) Run an ALTER DATABASE and specify the WITH MOVE clause, take the database offline, move the files, bring the database back online.

    Make sure you take a backup first, just as a precaution.

    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

  • September 16, 2008 at 6:50 am

    #872321

    Hi

    you can also do this by setting the database to offline, use the alter database modify file statement and then set back to online after.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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