SQL2005 Multiple instances

  • 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 ?

  • If you want multiple servers then you need to install server only.

  • 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

  • Then, multiple instances will occupy huge space.. right ?.. i mean 2 instances will occupy double space

  • 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

  • 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