dbTalk Databases Forums  

Can you move SQL binaries to a new directory after it's been insta

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Can you move SQL binaries to a new directory after it's been insta in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
kzakoski
 
Posts: n/a

Default Can you move SQL binaries to a new directory after it's been insta - 07-22-2009 , 09:50 AM






A third party vendor installed SQL 2005 in an incorrectly named 'C:\Pogram
Files' directory. I've successfully moved the master, model, msdb db's to
the correct default 'C:\Program Files' but is there a way to move SQL
binaries to the correct location without uninstalling and reinstalling SQL
again?

Reply With Quote
  #2  
Old   
Lucas Kartawidjaja
 
Posts: n/a

Default RE: Can you move SQL binaries to a new directory after it's been insta - 07-24-2009 , 12:28 PM






Not that I am aware of. Even if there is a way to do this, I think it will be
much harder than uninstalling and reinstalling the SQL Server and then
restoring the databases or reattaching the database files. But I might be
wrong.

"kzakoski" wrote:

Quote:
A third party vendor installed SQL 2005 in an incorrectly named 'C:\Pogram
Files' directory. I've successfully moved the master, model, msdb db's to
the correct default 'C:\Program Files' but is there a way to move SQL
binaries to the correct location without uninstalling and reinstalling SQL
again?


Reply With Quote
  #3  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: Can you move SQL binaries to a new directory after it's been insta - 07-25-2009 , 05:55 AM



Some tools have to be there and you can't change the path for some certain
components of SQL Server.

--
Ekrem Önsoy - SQL Server MVP



"kzakoski" <kzakoski (AT) discussions (DOT) microsoft.com>, iletisinde şunu yazdı,
news:B919D75B-EAF3-4207-A79E-B630B6AD1BC9 (AT) microsoft (DOT) com...
Quote:
A third party vendor installed SQL 2005 in an incorrectly named 'C:\Pogram
Files' directory. I've successfully moved the master, model, msdb db's to
the correct default 'C:\Program Files' but is there a way to move SQL
binaries to the correct location without uninstalling and reinstalling SQL
again?


Reply With Quote
  #4  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Can you move SQL binaries to a new directory after it's beeninsta - 07-25-2009 , 11:07 AM



The problem is the "vendor" put it in the wrong folder:

C:\Pogram Files\

Instead of:

C:\Program Files\

I missed that in the first read as well. But the user doesn't want to move
things to a non-standard location; it is the opposite.

Anyway I agree with another post in the thread: even if there is a way (and
I can't think of a clean one), I would rather uninstall the instance and
start over than to try and muscle everything into the right location. Bill
the vendor for your time.






On 7/25/09 6:55 AM, in article
F355EBB4-182F-4B2C-94E6-57BB7F06BFBE...soft (DOT) com, "Ekrem Önsoy"
<iletisim@ekrem[REMOVETHIS]onsoy.net> wrote:

Quote:
Some tools have to be there and you can't change the path for some certain
components of SQL Server.

Reply With Quote
  #5  
Old   
Ekrem Önsoy
 
Posts: n/a

Default Re: Can you move SQL binaries to a new directory after it's been insta - 07-25-2009 , 12:03 PM



Aha! I missed that, thanks =)

--
Ekrem Önsoy - SQL Server MVP



"Aaron Bertrand [SQL Server MVP]" <ten.xoc (AT) dnartreb (DOT) noraa>, iletisinde sunu
yazdi, news:C690A611.20C4F%ten.xoc (AT) dnartreb (DOT) noraa...
Quote:
The problem is the "vendor" put it in the wrong folder:

C:\Pogram Files\

Instead of:

C:\Program Files\

I missed that in the first read as well. But the user doesn't want to
move
things to a non-standard location; it is the opposite.

Anyway I agree with another post in the thread: even if there is a way
(and
I can't think of a clean one), I would rather uninstall the instance and
start over than to try and muscle everything into the right location.
Bill
the vendor for your time.






On 7/25/09 6:55 AM, in article
F355EBB4-182F-4B2C-94E6-57BB7F06BFBE...soft (DOT) com, "Ekrem Önsoy"
iletisim@ekrem[REMOVETHIS]onsoy.net> wrote:

Some tools have to be there and you can't change the path for some
certain
components of SQL Server.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.