Reduced functionality with SQL Server 2000? RRS feed

  • Question

  • What are the downsides of using SQL Server 2000 instead of SQL Server 2005? What functions will be unavailable?
    Are there any gotchas?

    Thanks for your time!

    Wednesday, January 23, 2008 9:08 PM

All replies

  • Fundamentally the version of SQL Server (SQL 2000 / SQL 2005) does not have impact on the working of sharepoint.

    It all needs a database engine. If you want to go for SQL 2000 install with SP4 also.


    I could see few enhancements like SQL Reporting Services of SQL 2005, that may have some impact on the usage analysis reporting capability of MOSS 2007.


    Since SQL 2008 is released, i'd recommend to go for SQL 2005 atleast

    Thursday, January 24, 2008 6:40 AM
  • From a SharePoint perspective there is little difference. BUT from a SQL perspective 2005 adds failover and data recovery options that are not available in SQL 2000.


    If you are considering wich way to go, go 2005. If you have an existing SQL 2000 environment and want to add SharePoint you can, but understand the data protection requirements first.


    The upgrade to 2005 from 2000 can impact applications, so you need to do your homework!




    Saturday, February 23, 2008 1:44 PM