SQL 2005 instance

Posted on 2012-09-14
Last Modified: 2012-09-17
I have a database called 'abc' on server A, which is backed up full then restored to server B overnight so that our developer can utilize the database on server B for testing purpose. Both server A and B are very old, so I need to replace.

Instead of having two SQL servers, I'm thinking of having two instances on new single server. Will two instances give any trouble?
Question by:crcsupport
    LVL 9

    Assisted Solution

    Check the following thread for more infomration for best practices on multiple sql server instances on single server.
    LVL 1

    Author Comment

    This link doesn't answer my question. The database name will be the same but on different instances, one for production, one for testing environment.
    I want to make sure the two complete database runs on different instances, does't create any problem, conflict.
    LVL 6

    Accepted Solution

    Hi  crcsupport,

    Yes you can have multiple instance running on a single server. Though there is maximum no if instances you have on a single server /PC..

    You can have one default and multiple named instance. Just giving server name would allow you to connect to the default and servernameamed_instance would allow you to connect to named instance.

    You can have the same database names on each instance and be able to restore from one instance to the other.

    Also note Using multiple instances is acceptable if you have enough resources available.

    Hope this helps,

    LVL 38

    Assisted Solution

    by:Jim P.
    That can work.

    The issue I would worry about is that a developer damaging/altering/modifying a production database by accident.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

    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

    21 Experts available now in Live!

    Get 1:1 Help Now