Sharepint foundation

Posted on 2012-08-31
Medium Priority
Last Modified: 2013-01-08
I have sbs11 and i am using sharepoiunt foundation server with SQL2008 r2 install on the sbs11
the issue is the i got a problem size limit of the databse 10240 exceeding and not abloe to add any document to the sharepoint
the error is :

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
 help plese
Question by:bugs-it
  • 2
LVL 26

Expert Comment

ID: 38353867
The SQL 2008 R2 license that comes with SBS 2011 is the express version and has a maximum limit of 10240mb so this cannot become bigger.

Because the SQL installation on SBS 2011 is used for more than only sharepoint (Windows Internal Database) you need to be very carefull with upgrading the instances to a SQL 2008 R2 standard.

Please look at this blog post for additional information: http://blogs.technet.com/b/sbs/archive/2011/02/28/how-to-migrate-companyweb-to-a-sql-2008-r2-standard-instance-on-sbs-2011-part-1.aspx

if you want to migrate to another server look here: http://technet.microsoft.com/en-us/library/gg616007.aspx

Accepted Solution

bugs-it earned 0 total points
ID: 38417213
This worked 100% sure, and with only 5 steps:

1-  Go to your existing Sharepoint foundation 2010 server

2- Open CMD (as administrator) type:
    2-1 CD C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN
    2-2 STSADM.exe -o export -url "http://yourwebsite" -filename "Youwebsire.bak" -includeusersecurity

Note: Dont Close the CMD before the Operation Finish This will create in the directory you mentioned arroud 300 Files like the Backup name you choosed.

3- Prepare A new server with SQL Server 2008 r2 and Sharepoint server 2010,
Create a new Web Application with the same name of the old one, Create w Site inside the webapplication also with the same name

5- Now Go to the old Server Stop the IIS, Remove the DNS CNAME of the OLD site from the DNS server, And recreate A CNAME if same site With the new server Name on the DNS server

6- Now Copy The <300< File created in the location mentioned above on the old server to the same location on the new server,

7- Access CMD of the new server and run the following Command:
  7-1 CD C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN
   7-2 STSADM.exe -o Import -url "http://yourwebsite" -filename "Youwebsire.bak" -includeusersecurity

The Import Oporation will take time according to you data,

After that, YOur website ( as it was) will be running on the new server installed

Hassan AKIL

Author Closing Comment

ID: 38694077
was a solution for me

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question