create a new instance on ms sql server 2005

Posted on 2007-08-02
Last Modified: 2008-09-19
Create a new instance on ms sql server 2005
Question by:nmssgic
    LVL 19

    Expert Comment

    by:Stephen Manderson
    Hi there,

    In order to add another instance of SQL you are required to install a new installation with a new name which of course would require an additional license.


    Author Comment

    We have SQL 2005 standard edition running on wk3 server...  We've had a consultant set up a new instance on the machine in the past without requiring access to installation, etc.  Could he possibly have done something different to make this work?  We are installing backup exec on the machine and it needs an sql instance.  Would it be better to let it install  it's own sql2005 express instance?  I wanted to capitalize on the sql server installation we already had.

    Paul Collins
    LVL 27

    Accepted Solution

    >>We've had a consultant set up a new instance on the machine in the past without requiring access to installation, >>etc.  Could he possibly have done something different to make this work?

    An instance is a copy of SQL Server. You can have multiple instances of SQL Server running on one computer. You will have to monitor the resources of each copy. Do you mean instance or database?

    Because an instance is a complete SQL Server installation, you need the installation disks.

    BackupExec wants to install another instance (copy of SQL Server). If you want all of the features of BackupExec, then it should have its own instance:

    If you install into a current instance, you will not have Cluster Configuration Wizard, and the automated Master backup.

    LVL 1

    Expert Comment


    PTJCB is correct, in order to install another instance of SQL Server on the same machine you will need the installation disks to do that.  However if memory serves, during the installation of Veritas you can specify which SQL Server to use if you have a SQL Server already existing.  Check the installation manual or online help from Veritas for the installation procedures using an existing.  However this will remove the ability to restore the Master database to the SQL Server that Veritas is running from.  If you need to be able to recover the Master database, then installing Veritas using the existing SQL Server installation would not be a good option for you.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Want to promote your upcoming event?

    Are you going to an event? Are you going to be exhibiting at a tradeshow? Talking at a conference? Using a promotional banner in your email signature ensures that your organization’s most important contacts stay in the know and can potentially spread the word about the event.

    Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now