We have had a consultant set up a sharepoint 2010 server for us to use for document management. I believe it is just on the basic (free) sharepoint that comes with windows server.
From what I understand this uses sql server express 2008r2 which has a 10GB size limit. I am under the impression that full sharepoint can store file content outside of the database but that with our version they are stored in the database and am worried we will run out of space and suddenly our staff will not be able to work any more.
Is this a reality – will it just stop working when we run out of space?
Are they any ways we can stretch the sql server express database, perhaps by using multiple databases?
How can we monitor the size of the database so we can predict when we might need to upgrade to full sql-server?
Best Answer
When you installed SharePoint did you do a Single Server install or Custom install and put everything on one server? That may have an impact. SharePoint 2010 Foundation can use SQL 2008(R2) as well as Express
I don't believe Express will support multiple servers.The off server storage ( Remote BLOB Storage) will allow you to keep larger files like video and others on a disk on the local system. MS has more info here on BLOB storage RBS with SP Foundation This can save SQL space and possibly improve performaqnce in some cases.