Learn how to a build a cloud-first strategyRegister Now


SQL Server 2005 installation question

Posted on 2007-07-31
Medium Priority
Last Modified: 2010-03-19
installing sql server 2005 standard on windows server 2003 r2 enterprise

i have OS on RAID 1 and i also have a RAID 5 array
i am installing SQL Server in prep for a vendor who will install a SQL DB.  i want that SQL DB on the RAID 5.  is this specified in the SQL installation, or can it be done later when the DB instance is created?

will SQL install a default DB during installation?  if so, where should i put that default instance knowing that i want the SQL DB the vendor will set up on the RAID 5?

am i correct to install the SQL Server program on the OS RAID?  it's just the DB instance that will go on the RAID 5, right?
Question by:zephyr_hex (Megan)
  • 3
  • 2
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 19602071
With SQL 2005, you can define the disk location of each databae or part of a database.
SQL Server installs some default database information. (Master, Tempdb...)

if so, where should i put that default instance knowing that i want the SQL DB the vendor will set up on the RAID 5? Up to you, and your scenario and usage. What is on each drive, how will usage impact, etc.


Expert Comment

ID: 19602091
If you are installing through the Installation Wizard you can select the data directory which will be default for created databases.

This is done on the screen where you select which components should be installed, at the bottom of the window you will see the directory. This way you could install the SQL Server binary's on one disk and the data files on another.

It is fine to install the SQL Server program on the OS disk as long as this is not a large volume production type box, in that case it is recommended that you have a different disk/array for the OS files, Program Files(including SQL Server), Data Files, and Log files.

If this isn't a large production installation than you can get away with having the disks arranged the way you have posted, otherwise you may want to look into getting some additional RAID arrays.
LVL 44

Author Comment

by:zephyr_hex (Megan)
ID: 19602172
this isn't a large production DB.  just a DB for reporting purposes.

i am working through the installation wizard.  for the Feature Selection, it lists the various services to be installed, and i currently have them all going to the default OS drive.  i'm assuming those services are not the same thing as the DB instances and that i'll be prompted later on for the DB instance locations.

since i don't know how the vendor will set up their instance, i guess i'll take the default instance during this installation.  the vendor will be creating their own instance later.
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

LVL 44

Author Comment

by:zephyr_hex (Megan)
ID: 19602547
well, i worked my way through the installation wizard and never saw an option to specify the drive/array that the DB instance goes on...

i'm not really concerned about this initial default instance...

but when an instance is created in the future, will i be able to specify the location?  or do i have to change something in the initial installation to allow future DB instances to be located on the other array?

Accepted Solution

DantheDBA earned 2000 total points
ID: 19602874
Just to clarify SQL vocabulary...an Instance generally refers to a separate installation of SQL server, so to install additional instances you would have to set them up by running the wizard again.

A single instance can host multiple databases, each database can have specific data and log file locations. The file locations can be specified when the database is created, or if they provide you with a backup to restore the database you can specify the file locations in the restore statement by using 'WITH MOVE ....'

If you want to specify a new default location for data files this can be done in SSMS by right clicking the server properties and selecting the Database Settings page, there you can set a default location, but even if you dont you will still be able to specify the exact location upon either creating or restoring the new database from your vendor.
LVL 44

Author Comment

by:zephyr_hex (Megan)
ID: 19603186

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IF you are either unfamiliar with rootkits, or want to know more about them, read on ....
It is a real story and is one of my scariest tech experiences. Most users think that IT experts like us know how to fix all computer problems. However, if there is a time constraint and you MUST not fail the task or you will lose your job, a simple …
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question