locked
Difference between WSS 3.0 and Sharepoint foundation 2010 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I would like to know what are all new features added in Sharepoint Foundation 2010 as compare to WSs 3.0?
    Thursday, February 25, 2010 7:15 AM

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote
    First a major negative.

    The basic installation no longer installs a no-size-limit database system. Instead it is restricted to 4GB (yes you can extend this to maybe 22GB using other storage but it's messy)

    --------------

    Pluses

    - use of ribbon (a plus?)

    - much better administration    

     (for instance instead of needing to open the log file settings separately (or ca 15 times) there is one page with all the settings listed where they all can be amended.)

    - ability to use Office 2010 additional functions


    Frankly I've not noticed much else - there's nothing that really grabs you like the recycle bins and better versioning last time around.



    FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
    Complete Book Lists (incl. foreign language) on each site.
    Thursday, February 25, 2010 10:37 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,
    added to Mike,
    Please check the following
    - http://msdn.microsoft.com/en-us/library/ee539826(office.14).aspx
    - http://technet.microsoft.com/en-us/sharepoint/ee518670.aspx

    Best Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.
    Thursday, February 25, 2010 2:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    The OOB limit is 4GB for the Basic installation (or Advanced + single-server option installation) which installs a (normal) copy of SQL Server 2008 Express.  (*)

    (The equivalent in WSS 3.0 was a special version of SQL Server 2005 Express called Windows Internal Database that had no limit.)

    There continues to be no limit when full SQL Server versions are used as the db system.


    (*) You can have larger databases than 4GB by using additional storage through a technique (RBS - Remote Blob Storage) but I don't fancy messing with it.


    FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
    Complete Book Lists (incl. foreign language) on each site.
    • Edited by Mike Walsh FIN Friday, February 26, 2010 9:20 AM Edited with correct name (remote blob storage) rather than inaccurate guess which had a B too many (RBBS)
    • Marked as answer by Margriet Bruggeman Tuesday, April 17, 2012 12:35 PM
    Friday, February 26, 2010 5:12 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    There is a lot of information already on here but Portal Front SharePoint Hosting has details it on their site along with a lot of other useful info.
    • Edited by deidreand8 Monday, December 13, 2010 4:39 PM Change in URL. Needed to update.
    • Marked as answer by Margriet Bruggeman Tuesday, April 17, 2012 12:35 PM
    Tuesday, June 29, 2010 2:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Here is a link from Priyo Lahiri: http://blogs.msdn.com/b/priyo/archive/2010/04/27/configure-remote-blob-storage-rbs-with-filestream-for-sharepoint-foundation-2010.aspx

    "For all of you guys who has WSS 3.0 running on Windows Internal Database, when you install SharePoint Foundation 2010, it installs SQL 2008 Express which has the 4 GB limit. So when you are thinking about upgrading to 2010 and have a Content DB larger than 4 GB you got a few options:

    •  
      • Move the full blows SQL
      • Move to SQL 2008 R2 Express (10 GB Limit)… Read more here.
      • Install and Configure Remote BLOB Storage. "
    Serge Luca; MVP blog: http://sergeluca.spaces.live.com Devoteam Belgium. http://twitter.com/sergeluca
    Tuesday, June 29, 2010 6:39 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Mike, here is the official note on SQL Server 2008 R2 Express 10 GB limit:

    http://msdn.microsoft.com/en-us/library/cc645993.aspx#Scalability

     

    Thanks & Regards,
    Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, June 30, 2010 10:55 AM

All replies

  • Question
    Sign in to vote
    2
    Sign in to vote
    First a major negative.

    The basic installation no longer installs a no-size-limit database system. Instead it is restricted to 4GB (yes you can extend this to maybe 22GB using other storage but it's messy)

    --------------

    Pluses

    - use of ribbon (a plus?)

    - much better administration    

     (for instance instead of needing to open the log file settings separately (or ca 15 times) there is one page with all the settings listed where they all can be amended.)

    - ability to use Office 2010 additional functions


    Frankly I've not noticed much else - there's nothing that really grabs you like the recycle bins and better versioning last time around.



    FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
    Complete Book Lists (incl. foreign language) on each site.
    Thursday, February 25, 2010 10:37 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,
    added to Mike,
    Please check the following
    - http://msdn.microsoft.com/en-us/library/ee539826(office.14).aspx
    - http://technet.microsoft.com/en-us/sharepoint/ee518670.aspx

    Best Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.
    Thursday, February 25, 2010 2:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Mike,

    Are you saying that the OOB size limit for Foundation 2010 is 4GB?  I couldn't quite work it out from your statement above?

    Does this limit apply even if connected to a full SQL Server rather than SQL Express?

    Thanks,

    Kyle.
    Thursday, February 25, 2010 10:48 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    The OOB limit is 4GB for the Basic installation (or Advanced + single-server option installation) which installs a (normal) copy of SQL Server 2008 Express.  (*)

    (The equivalent in WSS 3.0 was a special version of SQL Server 2005 Express called Windows Internal Database that had no limit.)

    There continues to be no limit when full SQL Server versions are used as the db system.


    (*) You can have larger databases than 4GB by using additional storage through a technique (RBS - Remote Blob Storage) but I don't fancy messing with it.


    FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
    Complete Book Lists (incl. foreign language) on each site.
    • Edited by Mike Walsh FIN Friday, February 26, 2010 9:20 AM Edited with correct name (remote blob storage) rather than inaccurate guess which had a B too many (RBBS)
    • Marked as answer by Margriet Bruggeman Tuesday, April 17, 2012 12:35 PM
    Friday, February 26, 2010 5:12 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    There is a lot of information already on here but Portal Front SharePoint Hosting has details it on their site along with a lot of other useful info.
    • Edited by deidreand8 Monday, December 13, 2010 4:39 PM Change in URL. Needed to update.
    • Marked as answer by Margriet Bruggeman Tuesday, April 17, 2012 12:35 PM
    Tuesday, June 29, 2010 2:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    About the 4GB limit of SQl Server Express, it looks like Sql Server 2008 R2 express 2008 provides now 10 GB.
    Serge Luca; MVP blog: http://sergeluca.spaces.live.com Devoteam Belgium. http://twitter.com/sergeluca
    Tuesday, June 29, 2010 3:20 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I'd like to see a link where it says that.

    I'm fairly sure I checked when SQL Server 2008 Express came out and it was still 4GB.

    If it's now 10GB it must (?) only be since R2.

     

    (Off-Topic: It makes you wonder why SPF 2010 has a 4GB limit though. We'll need to all recommend using SQL Server 2008 Express R2 if the 10GB is true. Note: 2010 questions go to one of the 2010 forums here - http://social.technet.microsoft.com/Forums/en-US/category/sharepoint2010)

    2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
    2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
    Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
    Tuesday, June 29, 2010 4:38 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Here is a link from Priyo Lahiri: http://blogs.msdn.com/b/priyo/archive/2010/04/27/configure-remote-blob-storage-rbs-with-filestream-for-sharepoint-foundation-2010.aspx

    "For all of you guys who has WSS 3.0 running on Windows Internal Database, when you install SharePoint Foundation 2010, it installs SQL 2008 Express which has the 4 GB limit. So when you are thinking about upgrading to 2010 and have a Content DB larger than 4 GB you got a few options:

    •  
      • Move the full blows SQL
      • Move to SQL 2008 R2 Express (10 GB Limit)… Read more here.
      • Install and Configure Remote BLOB Storage. "
    Serge Luca; MVP blog: http://sergeluca.spaces.live.com Devoteam Belgium. http://twitter.com/sergeluca
    Tuesday, June 29, 2010 6:39 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    > Here is a link from Priyo

    This is by no means the sort of URL I was looking for.

    I need to see a URL that points to an official Microsoft statement before I believe such a major change.

    (I would also trust a Blog more if it were written in good English. But even then I wouldn't trust it enough - far too many people in the past said in Blogs that the Basic installation of WSS 3.0 was a database with a limit of 4GB)

    and the "Read more here" link you mention (from the Priyo blog) goes to a page with the Title "

    "Welcome to the MSDN Blogs!"  that has nothing at all about database limits.
    So the jury is still out on this one.
    2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
    2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
    Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
    Wednesday, June 30, 2010 9:59 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Mike, here is the official note on SQL Server 2008 R2 Express 10 GB limit:

    http://msdn.microsoft.com/en-us/library/cc645993.aspx#Scalability

     

    Thanks & Regards,
    Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, June 30, 2010 10:55 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Finally ...

    Thanks, Kamlesh. (How sneaky of them. They should have been shouting this from the rooftops. Pity my book has already gone through its final proof reading and is being printed. I'd have loved to included the recommendation to ignore Basic Installation and use SQL Server 2008 Express R2 instead.)

    Mike

     

    2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
    2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
    Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
    Wednesday, June 30, 2010 12:21 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    The below was extracted from MSDN Blog, which I am unable to locate now (FYI - Check the last question in the FAQ)

    Is the database size limit increased in all editions of SQL Server 2008 R2 Express?

     

    Yes, SQL Server 2008 R2 Express with Tools and SQL Server 2008 R2 Express with Advanced Services will allow 10GB databases as well.

     

    What about CPU and memory limits? Are any other limits changed in SQL Server 2008 R2 Express?

     

    No, the database size limit is the only limit we updated in SQL Server 2008 R2 Express.  SQL Server 2008 R2 Express is still limited to 1 CPU and 1 GB or RAM.

     

    Was the database size limit changed for previous versions of SQL Server Express?

     

    No, the database size limit in previous versions of SQL Server Express (including SQL Server 2005 Express and SQL Server 2008 Express) stays unchanged at 4GB.

     

    Was the database size limit changed in November CTP for SQL Server 2008 R2 Express?

     

    No, the 10 GB database size limit is only available in the final release of SQL Server 2008 R2 Express and not in previous Community Preview releases.

    UPDATE: OK, I got the source link.  Its here :-)

    http://blogs.microsoft.co.il/blogs/adlaim/archive/2010/04/29/express-2010-rtm-download-summary.aspx 

    Thanks & Regards,
    Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    • Edited by KSDN Wednesday, June 30, 2010 1:03 PM check UPDATE
    Wednesday, June 30, 2010 12:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Nice Info, Saved my time to quick start my work !!!
    Thanks in Advance !!! Cheers !!! Praveen Mandalapu
    Tuesday, January 4, 2011 5:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi ,

    You mean to say one can install WSS 3.0 on Windows server 2003 and there wont be any limitation for database.

    And ther is 4GB limitation of database on share point foundation server .

    Kindly reply with just yes or no.

    I want to install WSS 3.0 with in built no limitation database is it possible ?

     

     

    Monday, October 17, 2011 10:59 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    could you tell me if is it possible to install Sharepoint foudation winth a SQL 2008 Server?.

    I would like to quite exchange 2007 public folders that I use to public general mails and use sharepoint 2010 to publish those mails for what I need more or less 50 Gb for database content.

    Thursday, April 26, 2012 2:32 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    you can install SharePoint Foundation to Windows 7 Proffessional

    there was no way to install WSS without a virtual machine on my laptop

    ceren

    Thursday, April 26, 2012 3:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Mike, thanks for sharing useful information.

    http://support.jesoba.com
    Errors, Troubleshooting, Problem Cases, Performance Monitoring, Best Practices etc.

    Tuesday, May 22, 2012 5:42 PM