Sharepint foundation

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
bugs-itAsked:
Who is Participating?
 
bugs-itConnect With a Mentor Author Commented:
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
SYSTEM ENGINEER
BUGS-IT
0
 
ronnypotCommented:
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
0
 
bugs-itAuthor Commented:
was a solution for me
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.