Post reply

SQL Server 2000 Multiple Instances

  • November 8, 2007 at 2:00 pm

    #179256

    Hi Everyone,

    I have MS SQL Server 2000 Standard Edition installed on the server.

    I would like to create another instance which will be exact copy of the default one.

    Can I install on the same partition? How?

    Does Standard License allow us to install multiple instance?

    Thanks,

    Regards

  • November 8, 2007 at 11:29 pm

    #749722

    Well, quick answer is yes...

    install a named instance of SQL 2000 on a server with an existing instance and define where you want files to be placed, whichever disk partition you choose.

    Regarding maximum number of instances, or liscencing...

    http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx

    also... check this page out... but haven't validated any statements

    http://www.altoimaging.com/AltoWeb/Products/ContentMgmt/SQL_LicenseInfo/20Seat-SQLServer-License.htm

    Todd Carrier
    MCITP - Database Administrator (SQL 2008)
    MCSE: Data Platform (SQL 2012)

  • November 8, 2007 at 11:31 pm

    #749724

    to make exact copy of default instance..

    install named instance...

    restore master db, other sytem dbs, followed by user dbs on name instance

    Todd Carrier
    MCITP - Database Administrator (SQL 2008)
    MCSE: Data Platform (SQL 2012)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply