Results 1 to 6 of 6

Thread: changing file locations for a named instance after it was installed

  1. #1
    Join Date
    Dec 2002
    Posts
    50

    changing file locations for a named instance after it was installed

    Greetings -

    I have an instance name on a SQL server, and realized afterwards that I did not specify the correct data and log driver names. Is it possible just to copy the file locations who C:\Program Files\Microsoft SQL Server\MSSQL10_50.NAMEDINSTANCE\ to where I needed to be, I have two drivers (E:\LOG and F:\DB), or am I suppose to remove the instance and reinstall it to correct file locations?!

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You can specify db file path in server properties -> database settings in ssms. and follow steps in this link http://msdn.microsoft.com/en-us/library/ms345408.aspx to change system dbs' location.

  3. #3
    Join Date
    Dec 2002
    Posts
    50
    Quote Originally Posted by rmiao View Post
    You can specify db file path in server properties -> database settings in ssms. and follow steps in this link http://msdn.microsoft.com/en-us/library/ms345408.aspx to change system dbs' location.
    Hello,

    I did know how to change the location for the data and log files, my question was more about the installation part itself. When you create the instance, SQL puts the files where you tell it to save it during the creation procedure. I just removed the instance and reinstalled it so it is saved to where it should be. I initially put the MSSQL folder files under C, that is what I wanted to change.

    Thanks,
    Lava

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You have to uninstall/reinstall. Only things that can be easily change is database file locations including system database files. To relocate binaries, just scratch and reinstall.

  5. #5
    Join Date
    Dec 2002
    Posts
    50
    Yes, that is what I did...

    Thanks,
    Lava

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Don't have to reinstall in fact, just modify related registry keys and move files.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •