MSDE SHAREPOINT, MSDE SBSMONITORING, MSDE LIVECOMMUNICATIONS, SQL NORTHWIND --> 1

Discussion in 'Windows Small Business Server' started by Anonymous Coward, Apr 16, 2004.

  1. There have been many posts about upgrading MSDE instances to SQL and so on,
    but they all seem to result in having multiple instances of the SQL server
    process running. Is there a way to cleanly, organise all the databases in
    such a way that there is only ONE SQL server process running that serves all
    the tables required?

    i.e. A default install on SBS2003 premium with LiveCommunicationsServer
    would result in the following separate instances:
    1. MSDE SHAREPOINT
    2. MSDE SBSMONITORING
    3. MSDE LIVECOMMUNICATIONS
    4. SQL DEFAULT

    Assuming there is no live data that needs to be backed up or moved over, how
    could one merge all these into a single SQL instance, or set this up fresh
    in this way?

    The purpose of this is to use memory more efficiently, and make applying SQL
    patches easier as there's only 1 instance, not 4.
     
    Anonymous Coward, Apr 16, 2004
    #1
    1. Advertisements

  2. You'd have to hack all the applications around to point them to one
    common instance, and then get all the databases loaded into that single
    instance. I'm not sure that it's even possible.

    Personally, I wouldn't bother. It won't make much difference
    memory-wise, and you're far more likely to break the applications, or
    land up with a configuration that MS won't support.
     
    Steve Foster [SBS MVP], Apr 18, 2004
    #2
    1. Advertisements

  3. Thanks Steve, I guessed this was the most likely situation.
     
    Anonymous Coward, Apr 19, 2004
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.