How many MSDE databases are Too Many?

Discussion in 'Windows Small Business Server' started by Brian, Oct 25, 2006.

  1. Brian

    Brian Guest

    I have a SBS standard installation with many MSDE databases running -
    SHAREPOINT, WSUS, SBMONITORING, a Veritas Backup Exec BKUPEXEC, a Veritas
    Backup Exec BKUPEXECDLO, and MICROSOFTSMBIZ (SBA).

    So how many instances for MSDE are too many?
    When do you consider upgrading to SQL Server (or SBS Premium)?
    If you upgrade to SQL, will it pgrade the MSDE instances or will it be done
    mannually?
    What adavantges would there be to running a SQL Server for these instances
    (managment, administration, optimization, backup, maintenance, etc.)?

    Thanks!
    (And BTW, links to instructions are alway appreciated!)
     
    Brian, Oct 25, 2006
    #1
    1. Advertisements

  2. Brian

    bass_player Guest

    You can have as many instances as you like (technically, it's 16 instances
    per server and 32, 767 databases per instance) depending on how you want to
    manage them. I wouldn't recommend upgrading to SQL Server 2000 (what am I
    saying...) unless there is really a need to do so and there is a business
    benefit in doing so, like running line-of-business applications which are
    only supported in SQL Server 2000. The only problem with MSDE for most
    administrators is the CLI-type where you have to have a T-SQL manual by your
    side while doing administration as you do not have a GUI tool like Enterprise
    Manager. GUI (Enterprise Managerin SQL Server 2000) is just for ease of use.
    You can do everything in T-SQL using scripts
     
    bass_player, Oct 25, 2006
    #2
    1. Advertisements

  3. Brian

    Brian Guest

    Thanks.

     
    Brian, Oct 25, 2006
    #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.