Post reply

Data and Trans log location change to a new drive

  • May 7, 2008 at 12:42 am

    #121943

    I have a new server with 3 drives arrays, 1 for data that is quite large, 1 for the trans logs and lastly the OS.

    I ended up being called away from the office for an urgent issue and an intern said, done it before I'll install SQL 2005 for you. He installed everything to the OS drive. Is there a good procedure to move the database and Trans log files to the originally intended drives without reinstalling everything?

    Any suggestions would be appreciated.

    B.

  • May 7, 2008 at 12:56 am

    #811596

    User databases or system databases?

    User databases are easy. Detach, copy the files, reattach. The system ones are a lot more tricky and the method is different for each one.

    There's probably not much point in moving master or model, but the rest, sure.

    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

  • May 7, 2008 at 4:33 am

    #811652

    Hi ,

    what gail said is rite.

    using detach and attach functions u can move the db to new locations.

    for more information see the link

    http://support.microsoft.com/kb/224071

    regards,

    N.Prabhakaran

  • May 7, 2008 at 7:44 am

    #811783

    Thanks for the help and the tech note link.

    Appreciate it greatly..

    B.

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

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