Skip to Content
author's profile photo Former Member
Former Member

Multiple database instances on single server on SQL2005

Hi,

Client wanted to install multiple database (ECC,XI,BIW,EP)in single

server using SQL2005. CI is different server but datase is common server

with multiple databse instances.

My question is how to install second SQL database instance setup.exe

with diffrent named SID like first SQL installation . Or we just need to

copy binaries files only then install SAP databse instance.

for ex:I know oracle on Unix we need to copy only \oracle\C11\ora92

need to copy in \oracle\D11\ora92 , no need to setup setup.exe.

Like that in SQL2005 for second instance what we have to do. We just

copy installbles binary files or we have to setup.exe for second databse

also.

Please suggest .

Thanks

Lisa

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Sep 05, 2006 at 07:49 AM

    Hello,

    you have to run Setup again to install a so called 'Named Instance'. Copying the binaries will not work.

    All three possible scenarios (Multiple databases in one instance, multiple instances with single databases, multiple components in one database (MCOD)) are supported. These are main differences:

    • Multiple instances

    You can administer the instances seperatly without affecting the others. Memory and resource setting can be set for each instance.

    • Multiple databases in one instance

    Less administration overhead, Maintenace will affect all databases (e.g. necessary shutdown of all systems). The systems will compete against each other for memory and other ressoirses (IO), as all are running in the same instance.

    • MCOD system

    Only one instance and one database, Maintenance will affect all systems as they are stored in one database. Possibility of a syncron backup of all systems. Larger Backups as all systems have to be backed up evertime.

    For the given scenario i would recommend multiple instances at least for the EP and the BW.

    Best regards

    Clas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2006 at 08:07 AM

    Hi Lisa,

    please also have a look at service.sap.com/msplatforms -> SQL Server -> Installation of SQL Server 2005 in an SAP Environment.

    Sven

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello

      On the SQL 2005 SP1 DVD from SAP you will find a file called SQL4SAP.VBS. Run this file and when it asks you for the instance name type the SID of the system you want install.

      There may be a informational message about the use of named instances, you can ignore this message.

      You may wish to carefully investigate the allocation of resources on the server that is to be used as the database server for ECC, XI, BI and EP.

      Adequate resources such as memory, CPU and disk should be allocated to each database instance. CPU and memory can be changed dynamically. Disk resources can be changed, but this cannot be done online.

      I also recommend you do not install SQL in this manner unless you are using Windows for Itanium systems or Windows for x64 systems. The hardware, database and the OS must be 64bit or you will have performance problems.

      I recommend you refer to the installation guide and review OSS note:

      879941 Configuration Parameters for SQL Server 2005

      928839 SBO: Release planning for Microsoft SQL Server 2005

      Good luck

      N.P.C

      (Please do not cross post and please use the SQL forum for SQL questions)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.