Re: 1 server 2 SQL apps

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 17:25:54 +0530

Hi,

Does it make sense in this situation to use MSDE 2000 SP3, or will we
regret this soon ?

MSDE has a limitation of 2 GB per database as well as you will not get the
clients lke query analyzer, Enterprise manager.

Best option for you might be , Install a default installation of SQL server
standard edition and create 2 databases.
1 database each for application. 

--
Thanks
Hari
MCDBA
"Citizen" <citizen_NOSPAM@hotmail.com> wrote in message
news:1rl2e0td879ajl17du64p4hm62djis9keg@4ax.com...
> My question is how to best setup a new server that will host 2 SQL
> server applications for two different departments of the company.
>
> The first application will run up to 10 clients with very low
> concurrent activity. Estimated is that all the clients will log in in
> the morning in the application, and once in a while reference the
> database, or input some new data. Very low activity, my guess, but
> always logged in, ready for action.
> The second appliction will run up to 5 concurrent clients at the most.
> Clients will log in, do what they need, and close down their
> clientsoftware. There will be very low concurrent activity for this
> second application. And these are different users.
>
> Both applications can run MSDE 2000 SP3.
>
> How should I dimension this SQL server-configuration ?
> Does it make sense in this situation to use MSDE 2000 SP3, or will we
> regret this soon ?
> I could also choose to install a licence for SQL server 2000 standard
> and two instances of SQL server. Would that be a much preferred
> solution for the situation I tried to describe? Are there best
> practices for such a situation ?
>
> I would like to install MS Windows 2003 as OS.
> The system is a Proliant DL360 - 1 GB RAM - 2x 36 GB RAID 1
>
> Your advice is welcome.

Relevant Pages

  • Re: SP3 for MSDE 2000
    ... instances of SQL Server and MSDE. ... International customers should call their local subsidiaries. ... > Better than that - I just found out that the default new instance that SP3 ...
    (microsoft.public.sqlserver.security)
  • Re: SP3 for MSDE 2000
    ... instances of SQL Server and MSDE. ... International customers should call their local subsidiaries. ... > Better than that - I just found out that the default new instance that SP3 ...
    (microsoft.public.security)
  • Re: SQL Patch not working on Professional
    ... Then you have MSDE and need to download the MSDE patch. ... > the information saying system info the version shows SQL ... >>What edition of SQL Server and which SP3 are you using? ...
    (microsoft.public.sqlserver.security)
  • Re: I am getting incorrect responses to complicated Count() Query...
    ... I would LOVE to keep ACCESS/JET, but we have hundreds of clients and all too ... I love the fact that deploying JET is free as would MSDE be free. ... > suggest you use MS SQL Server Developer version, rather than MSDE, because ...
    (microsoft.public.access.queries)
  • Re: 1 server 2 SQL apps
    ... of your databases, but even a single processor machine with 1GB of RAM ... Regarding which to go with (MSDE or SQL Server). ... > The first application will run up to 10 clients with very low ...
    (microsoft.public.sqlserver.server)