Sharepint foundation

Posted on 2012-08-31
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
    LVL 26

    Expert Comment

    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:

    if you want to migrate to another server look here:

    Accepted Solution

    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

    was a solution for me

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Citrix XenDesktop 7.6 Citrix Policies Graphics
    VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    794 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now