Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2001
    Location
    Paradise
    Posts
    11,868

    Question Microsoft SQL Server 2000 Question to ask?

    I got an offer for Microsoft SQL Server 2000 today, what questions should I ask to know if can it work in a shared enviroment?
    sorry if this its a silly question, but I'm kinda donkey when I talk about Windows Licenses.

    Thanks in advance.

    Mods: if this its not the correct forum, feel free to move it.
    Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
    LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Email/Helpdesk Support
    Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
    DowntownHost LLC - In Business since 2001- West/Center/East USA - Netherlands - Singapore

  2. #2
    Make sure it is one of these versions of SQL Server 2000 listed below otherwise it will not work well with more than 10 users.


    SQL Server 2000 Enterprise Edition
    Used as a production database server. Supports all features available in SQL Server 2000, and scales to the performance levels required to support the largest Web sites and enterprise online transaction processing (OLTP) and data warehousing systems.

    SQL Server 2000 Standard Edition
    Used as a database server for a small workgroup or department.
    http://www.ChicagoJobResource.com
    Chicago Job Resource
    YOUR career connection for Chicago jobs, careers and employment

  3. #3
    Join Date
    Apr 2001
    Location
    Paradise
    Posts
    11,868
    Thanks
    Anything else that I should ask?
    Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
    LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Email/Helpdesk Support
    Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
    DowntownHost LLC - In Business since 2001- West/Center/East USA - Netherlands - Singapore

  4. #4
    Number of connections (Number of Client Access Licenses) is the most important thing you must ask.

    Also SQL Server 2000 standard supports databases under 4G and enterprise does not have any limit.

    Mac

  5. #5
    The size of a database cannot exceed 2 GB when using the SQL Server 2000 Desktop Engine or the Microsoft Data Engine (MSDE) 1.0.

    I am using 45G databases with standard edition and no problems at all.
    http://www.ChicagoJobResource.com
    Chicago Job Resource
    YOUR career connection for Chicago jobs, careers and employment

  6. #6
    Is your database file 45G or database along with log file?

    I think I have read this in a SQL server 2000 book that standard version has a limit of 4G.

    In fact I myself have databases of about (3G DB + 30G Log) but my databases have not gone over 4 yet.

    Mac

  7. #7
    data 45G log 3G

    Standard edition is used by over 200 clients many with database over 4G.

    Everything i posted, i copied right from the SQL books online?
    http://www.ChicagoJobResource.com
    Chicago Job Resource
    YOUR career connection for Chicago jobs, careers and employment

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •