Home / server / Questions / 370502
Accepted
Will Dennis
Asked: 2012-03-17 09:32:30 +0800 CST

Max size for a SharePoint Services 2.0 MSDE database?

  • 772

We're (still) running a SharePoint Services 2.0 installation consisting of one site that is using the "built-in" MSDE database for content storage. The current content database DB size is 2.1GB. I thought the max size for a MSDE DB was 2.0GB, but my boss tells me that the version of MSDE that is installed by SPS 2.0 does not have a limit (!)

Does anyone know if there indeed is a hard limit, and if not, what a good practical limit may be? I really cannot find anything on MSDN about this (and it is rather old software.)

Thanks! Will

sharepoint sharepoint-services

1 Answers

  1. Best Answer

    SPS 2.0 with a default install has a size limit of 2gb per database (which means the MDF and NDF file only). See this table for a list of limitations between MSDE and SQl server express 2k5. I believe tgeh guidance was to uprade to sql server express 2k5 when it shipped slightly after sps 2.0 (mainly for workload performance rather then size, as most users simply added more databases)

    • 1