Post reply

Move SQL Structure from C: drive to D: drive

  • December 4, 2008 at 1:22 pm

    #216045

    I need to move the sql structure from the c: drive to the d: drive

    c:\Program Files\Microsoft SQL Server\MSSQL.1, MSSQL.2, and MSSQL.3 to d:\MSSQL

    Are there any instructions anywhere to accomplish this?

    Many thanks!

  • December 4, 2008 at 1:41 pm

    #907912

    That's the MS SQL installation files, not just the system databases (master, msdb, model, resources)

    Only way I know how is to uninstall and re-install

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • December 4, 2008 at 1:54 pm

    #907920

    But SQL 2005 doesn't give you an option to place the SQL Server files anywere else, does it?

    I hope I don't have to re-install. I am trying to duplicate a new server with the old one and I have already moved all the databases to the new server and had the software vendors set up the software already. <B( One sad Newbie right here.....

  • December 4, 2008 at 2:11 pm

    #907935

    George Dickson (12/4/2008)

    But SQL 2005 doesn't give you an option to place the SQL Server files anywere else, does it?

    It does during the installation

    I hope I don't have to re-install. I am trying to duplicate a new server with the old one and I have already moved all the databases to the new server and had the software vendors set up the software already. <B( One sad Newbie right here.....

    Same as any other installed program. The binaries can't be moved without an uninstall and a reinstall and the correct location specified when installing. Works the same way as (for eg) Office.

    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

  • December 4, 2008 at 2:16 pm

    #907937

    OK, thanks! I guess I'll get started uninstalling and reinstalling.

  • December 6, 2008 at 8:32 am

    #908815

    George Dickson (12/4/2008)

    OK, thanks! I guess I'll get started uninstalling and reinstalling.

    backup and save your system databases first if you have already created logins, databases, etc

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

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

Viewing 6 posts - 1 through 5 (of 5 total)

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