August 22, 2008 at 9:42 am
Hi
I am fairly new to the SQL thing. We currently have 2 servers using running SQL and we have 3 more software coming soon that will need to use SQL 2005. My question is "Is there a way to install SQL 2005 on one server and have the 3 new DB run on that, instead of installing SQL 2005 on 3 new servers?" If it is possible can i have the db on an e:\ drive and have the software run from the c:\ drive?
August 22, 2008 at 9:49 am
probably need to clarify a little further what you are intending to do
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2008 at 9:53 am
You definitely can have 3 databases running on one server, whether this is better thatn running them on seperate servers would depend on a few factors, such as size of the databases and the sort of load you are expecting..
August 22, 2008 at 9:59 am
I agree with the last post, it really depends on your needs and the requirements of the software, etc. No one will be able to say do "X" wihtout more knowledge of user load, server specs, databases sizes, software requirements, etc.
SQL Server can support any number of datases on a single install (ok.. not any number, but more than 3 :)). So you can install multiple systems on one server. You can also put data, logs, install files, etc on various drive sets for performance reasons.
You also have the option of installing multiple instances of SQL on the same physical hardware to avoid having additional servers, but still getting the benefits of seperate SQL Server installs.
If you can post more info, we may be able to provide clearer direction. However I would suggest hitting google or a book store to read about SQL install options including instances as its a topic that is easy to understand, but the options and variations make it some what of an art and science to master.
August 22, 2008 at 10:00 am
What edition of SQL should i use to do this Standard or Enterprise?
August 22, 2008 at 10:06 am
Roger Moore (8/22/2008)
What edition of SQL should i use to do this Standard or Enterprise?
Again i would say that it depends on your needs and budget, have a look at this page that shows the features of each version.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Enterprise has support for more CPU's, but it is also a lot more expensive and could be over-kill for a small project.
August 22, 2008 at 10:08 am
You can install multiple databases, instances, drive locations, etc on all versions of SQL. Enterprise will get you additional features like advanced clustering (std provides basic clustering), data partioing, etc. Unless you expect to have a serious system, with serious performance needs, etc the Standard version will suffice.
Take a look at this link
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
August 22, 2008 at 12:20 pm
You need to check also if the apps can connect to specific instance if you want to consolidate. If they only connect using the machine name (instance less or the default one) you will need at least as many separate instance as you will have apps instead of only one with everything in it.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply