Announcement

Collapse
No announcement yet.

Limitations of MSDE

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Limitations of MSDE

    Hi all

    I need to move a few apps from a server that is slowly departing us! The apps in question are WSUS and Sophos Enterprise.

    I want to move them to a server that already has an application that uses MSDE (as does WSUS and Sophos). What i want to know is are there any serious limitations, implications etc... of doing this?

    Found this on google:

    http://aspfaq.com/show.asp?id=2343

    But it doesn't say anything about running multiple databases etc...

    Thanks

    Chris
    Server 2000 MCP
    Development: ASP, ASP.Net, PHP, VB, VB.Net, MySQL, MSSQL - Check out my blog http://tonyyeb.blogspot.com

    ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

  • #2
    Re: Limitations of MSDE

    http://msdn.microsoft.com/library/de.../msdeforvs.asp

    MSDE
    There is a hard 2-GB limit on data in an MSDE. However, multiple MSDE databases (each with a 2-GB limit) be supported by a single MSDE server.
    MSDE
    MSDE enjoys the full performance of SQL Server with five concurrent workloads or less. MSDE can support more than five concurrent workloads both from a technical and licensing standpoint, but Microsoft strongly suggests conducting application testing as appropriate to ensure adequate performance for greater than five concurrent workloads can be achieved. MSDE also supports row-level locking.
    and so on...
    maybe this is where you looking for ?
    Marcel
    Technical Consultant
    Netherlands
    http://www.phetios.com
    http://blog.nessus.nl

    MCITP(EA, SA), MCSA/E 2003:Security, CCNA, SNAF, DCUCI, CCSA/E/E+ (R60), VCP4/5, NCDA, NCIE - SAN, NCIE - BR, EMCPE
    "No matter how secure, there is always the human factor."

    "Enjoy life today, tomorrow may never come."
    "If you're going through hell, keep going. ~Winston Churchill"

    Comment


    • #3
      Re: Limitations of MSDE

      Yep that looks the business!!

      Many thanks

      PS - 1000th post... wooo hooo!
      Server 2000 MCP
      Development: ASP, ASP.Net, PHP, VB, VB.Net, MySQL, MSSQL - Check out my blog http://tonyyeb.blogspot.com

      ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

      Comment


      • #4
        Re: Limitations of MSDE

        MSDE go to be RIP in the near future.
        Try to "new" version of MSDE:

        http://www.microsoft.com/sql/express/default.mspx

        http://www.microsoft.com/sql/2005/pr...5features.mspx

        Regards,

        Yuval
        Best Regards,

        Yuval Sinay

        LinkedIn: https://www.linkedin.com/in/yuval14, Blog: http://blogs.microsoft.co.il/blogs/yuval14

        Comment

        Working...
        X