Installing databases to different hard drives.

Can't find anything on how to install to drives other than sys. I'm brand new to Servers and Databases in general and trying to learn. How do I get databases to install on drive partitions other than my main system drive?

Hi,

don′t know if you mean database or instance in your case. Databases can be installed (or created) on medias using the CREATE DATABASE statement using the file destination (more details in the BOL) or with the GUI placing the files whereever on your local disks or SAN you want.

The instance and therefore the server service files can be installed on every drive you want for SQL Server 2000, for SQL Server 2005, there has been (and probably there is even after SP1) the restrictions that the files can only be installed on the system partition.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||That helps I'll have to try and find it. I did mean the Database Files. Not the Server Software. The Help File on my installation doesn't work so I'm having to do alot of digging to find out what to do. When MMC opens for the Help File I get a Page Cannot Be Displayed. I also have this problem with IIS. Since IIS installed first I put the question on a Forum at ASP.net and haven't gotten an answer yet. Does anybody here have an Idea about why my help file doesn't work? I missed something or didn't enable something but I can't find it. Everything else seems to work but the Help File. Or do I need to start another thread about it here? Thanks for the help.|||Hi,

simply get the new books online, or reinstall the help files from the media. I had that once too,that the help files (or just the link) where corrupted.

http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en

(it′s the new BOL form April 2006)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||I uninstalled everything all the way back to IIS I think whatever it was may be OK now. I hope. Thanks.