Re: Help on choosing server software

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Gabe,

Thanks for the info.

I am DEFINITELY going to get at least a RAID 1 if not RAID 5.
I will probably go with and external USB 2.0 or Firewire HDD for backup, or
the new Iomega REV 35/90GB for backups over tape.

Any input on the OS for the server? Do I need to run 'server' software?

I am unclear as to the benefit of server software and 'CALS' for our
situation.

Thanks again,

Brian


"Gabe Knuth" <gknuth@xxxxxxxxxxxxxx> wrote in message
news:%23JzGx$XfFHA.1284@xxxxxxxxxxxxxxxxxxxxxxx
> You MAY be able to get away with the MSDE. I've tricked Citrix MetaFrame
> into working with MSDE (thinking it is a full-blown SQL server), and it
> works all right.
>
> The problem is that MSDE has a self-imposed governor on it, designed to
> gently push you in the direction of purchasing SQL server. After x number
> of connections (it's either 5 or 10, can't remember), it will slow down.
> This may still be all right for your company, though.
>
> One more word of advice. Get something with redundant storage. It might
> cost money, but you'll regret it the first time your hard drive dies if
> you don't. Tape backup is one thing, but drive redundancy is a huge
> consideration (and significantly less expensive than a tape solution).
>
> If you'd like to read the article about using MSDE with Citrix, you can
> check it out here: http://www.brianmadden.com/content/content.asp?ID=167.
> It might only be a little helpful to you, but it might get you pointed in
> the right direction.
>
>
>
>
>
> "Brian" <treddderx@xxxxxxxxx> wrote in message
> news:%231cHtzXfFHA.3944@xxxxxxxxxxxxxxxxxxxxxxx
>> Howdy all,
>>
>> Here is our company's situation:
>>
>> I have limited IT experience and have been designation the "IT guy".
>>
>> We currently are on a peer-to-peer network.
>> We need server to run MS SQL for ACT! and our document management
>> software.
>> We have 9 users who will be accessing the DBs.
>> We will use the server for backups of desktop PCs.
>> We have limited budgetary resources, so cost is a factor.
>> We won't be using the server for email
>>
>> Questions:
>>
>> 1) Do I need to run server software or can I just run WinXP Pro on the
>> server? Pros and Cons
>>
>> 2) For the DB applications, can I get away with MSDE instead of full MS
>> SQL?
>>
>> 3) Any other thoughts on the situation/solution?
>>
>> Thank you for your time and attention,
>>
>> Brian
>>
>>
>>
>>
>>
>
>


.

Relevant Pages

  • Re: MSDE help
    ... there is no limit to the number of connections on an MSDE server. ... I'm working with SQL Server Magazine to put together a weekly newsletter ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: version & instances
    ... Microsoft MVP ... Hitchhiker’s Guide to Visual Studio and SQL Server ... MSDE has a limited database size ...
    (microsoft.public.sqlserver.msde)
  • Re: version & instances
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... SQL 2000 SP3a for Antivirus app ... Consider that MSDE as a product is somewhat dated ...
    (microsoft.public.sqlserver.msde)
  • Re: Unable to connect to SQL 2000 engine on other machine from SSM
    ... I posted a bug report on Microsoft SQL Server Feedback. ... Upgrade MSDE to SP4: not ok. ... port information to your client. ...
    (microsoft.public.sqlserver.connect)
  • Re: Help with Master/Detail UI in ADPs
    ... No, MSDE is not limited to 5 concurrent users, it is limited to 5 concurrent ... The users whose connection to the server is idle at any moment don't count. ... and from the local temp table to the Detail table on the server for rows ...
    (microsoft.public.access.adp.sqlserver)