October 30, 2008 at 4:32 pm
Team:
I currently work for a company that requires sql server and all applications to be installed on a separate drive (D:) not on C: drive. Well being new here I noticed that applications are sure enough installed here and there. SQL Server specifically installed on C: drives. I would like to adhere to this policy and move these sql servers from one drive to the other.
To my knowledge SQL SERVER 2000 installations do not place everything on the designated drive path and still places some files on c: whether you like it or not. I am not sure if this applies to sql server 2005.
What I would like to know is how to do it for both. I have been trying to search on the internet on http://www.yahoo.com and find pretty much "nothing much" 🙂
Please help:
October 30, 2008 at 5:48 pm
In 2005 also, C: drive will hold some binary files
[font="Verdana"]--www.sqlvillage.com[/size][/font]
November 1, 2008 at 2:00 am
Thanks for confirming. Any idea where I can get more details to this delima?
November 1, 2008 at 11:03 am
Hi,
Do you mean that you have installed SQL Server on C:\ but you want to manually "move" it do D:\?
Basically, what you are asking for is ALL the steps (well, a lot of them anyway 😛 ) that the SQL Server setup does when you install SQL Server.
Well, I for one cannot provide them 🙂
Re-install is the only thing that springs to mind.
🙂
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 2, 2008 at 7:46 am
Reinstall is all you can do. There are too many things touched in the registry, files, etc.
You can easily detach databases, uninstall, reinstall, and attach them again.
November 3, 2008 at 3:03 pm
Thank you all for your timley responses.
November 10, 2008 at 5:11 am
The Readme file for SQL Server 2005 says how much space will be used on the system drive, and how much will be used for the program files if you direct the install to another disk. The Readme files for the SP upgrades have similar information for the additional space they require. While a SP is being installed, you normally need about 0.5 GB work space on the system drive, and a further 0.6 GB space in the system /Temp folder.
It is likely that after 3 to 5 years of applying maintenance to SQL Server 2005 you will use about 2.5 GB on the system drive, and about 0.5 GB on the program file drive. You need to plan the size of your system drive to allow for this.
The values for SQL Server 2008 will be different, but do not expect them to be lower.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
November 14, 2008 at 4:41 pm
I am so happy I came back to view my old posts.
Thank you for this great reference!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply