SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Install keeps defaulting to C Drive...why?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mar311
Starting Member

9 Posts

Posted - 05/24/2011 :  18:37:35  Show Profile  Reply with Quote
I've done many SQL server installs for multiple different versions but this has me stumped. We're on Windows Server 2008 Enterprise and installing SQL Server 2005 Std on it.

I have the local volume partitioned to a C and E drive. I have twice now done the install (after uninstalling) and each time it installs everything on the C drive when I clearly have set it to the E drive under the Advanced options before starting the install.

Has anyone else experienced this? Very odd. Any help would be greatly appreciated.

jeffw8713
Aged Yak Warrior

USA
790 Posts

Posted - 05/24/2011 :  22:04:39  Show Profile  Reply with Quote
Well, first of all - I would not recommend installing the binaries on the E:\ drive. I would recommend using the default location for the binaries, especially since there are components of the installation that will install on the C:\ drive no matter what you do.

Second, where are you actually changing the drive under Advanced? There are several levels...

When I setup SQL Server, I install binaries on the C:\ drive and change the data files location to my SAN or Data drive. This is done on the Advanced page, open up the database section and select data files. I change the location here - just specifying the drive letter. After the installation is complete, I then have on the SAN or data drive the following: E:\MSSQL.n\MSSQL\...

Jeff
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 05/25/2011 :  04:47:11  Show Profile  Reply with Quote
Theck the comment "Install SQL 2008 x64 to different volume than C:\" on this msdn article, it's for SQL 2008 R2 but I assume it works the same way for 2005 as well:

http://msdn.microsoft.com/en-us/library/ms143219(v=SQL.105).aspx

- Lumbago
My blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/
Go to Top of Page

lgr811
Starting Member

Mexico
2 Posts

Posted - 07/04/2013 :  12:22:31  Show Profile  Reply with Quote
any solution for 32 bits?

Leo
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000