September 4, 2008 at 1:44 am
I have to install multiple instances of SQL 2005 using unattended install scripts. Is it only the database engine that should be installed multiple times OR even client connectivity tools, Workstation development tools, analysis services, reporting services that should be installed multiple times ?
September 4, 2008 at 3:41 am
If you want multiple servers then you need to install server only.
September 4, 2008 at 4:18 am
Chandu (9/4/2008)
I have to install multiple instances of SQL 2005 using unattended install scripts. Is it only the database engine that should be installed multiple times OR even client connectivity tools, Workstation development tools, analysis services, reporting services that should be installed multiple times ?
You only have to install what you need !!
Apparently you did a full install (Db / As / RS / Is / client tools)
You can have multiple instances of the database engine and of analysis server at the same box !!
Off course you only need one set of client tools, if you need them at the server at all.
Easyest way to do it is by using setup ini files per instance.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 4, 2008 at 8:58 am
Then, multiple instances will occupy huge space.. right ?.. i mean 2 instances will occupy double space
September 4, 2008 at 9:26 am
How much space each instance requires depends on what you put in it. BOL states the minimum space requirement for each component. Add the space your data will occupy to what's listed here:
http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx.
Greg
September 4, 2008 at 11:53 pm
Chandu (9/4/2008)
Then, multiple instances will occupy huge space.. right ?.. i mean 2 instances will occupy double space
Your extra software will need space, your extra databases will need space, your extra running instance will need CPU and Memory, ...
If you're buying a car, without any seats, and you put in one seat (i.e. instance of a software), that will take some space, the engine will need to perform x% to get to move the car.
If you put in another seat, ....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply