Solved

SBS 2008, SharePoint 3.0 content database, and upgrade to SharePoint 2010

Posted on 2010-11-16
12
1,692 Views
Last Modified: 2012-05-10
I'm running Small Business Server 2008 Standard with SharePoint 3.0. I'm intending to upgrade to SharePoint 2010 Foundation. I ran the stsadm preupgradecheck and the only remaining issue is "Databases within this farm are hosted on Windows Internal Database and are larger than or close to 4GB in size." Then it lists ShareWebDb, and ShareWebDb.mdb is indeed around 4GB.

Point 1: I installed SQL Server Express 2008 R2, upgrading the SQLEXPRESS instance. I moved ShareWebDb to this instance following the instructions under "Moving the Windows SharePoint Services content database" at http://technet.microsoft.com/en-us/library/cc794697%28WS.10%29.aspx. Companyweb and the one sub-site are working fine. In SQL Server Management Console I see the ShareWebDb database under SQLEXPRESS and the SQLEXPRESS version is 10.50.1600. So don't I now have a 10GB limit and the preupgradecheck is raising a false alarm?

Point 2. I applied a huge quota template to companyweb, which is the only SharePoint site other than SharePoint 3.0 CCentral Administration, which is using a different content database. Under Storage Space Allocation the entire site and its sub-site is using 119.9 MB.That's all the content I have. Why is the ShareWebDb.mdb file 4GB, and is there any way to shrink it? (I regularly shrink the log file).
0
Comment
Question by:JonFleming
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34148283
point 1:  sql express 2008 still has the 4 GB storage limitation.  express is also limited to 1GB RAM, and 1 CPU.

0
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34148286
at some point EE will fix my default comment setting so it's not admin.  sorry about that.

point 1:  sql express 2008 still has the 4 GB storage limitation.  express is also limited to 1GB RAM, and 1 CPU.
0
 

Author Comment

by:JonFleming
ID: 34150224
SQL 2008 Express R2 has a 10GB per database storage limitation, see http://www.microsoft.com/express/Database/ under "Powerful" I already ran into the 4GB limit on another server; users couldn't upload files. Installed SQL Server 2008 Express R2, moved the content database, users could upload, no problem.
0
Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34156140
ah, well there you go.

i bet the preupgradecheck isn't aware of it either.

the only way to make the db smaller is to get rid of data, or shrink the db file.
0
 

Author Comment

by:JonFleming
ID: 34159473
Sure seems crazy that the database file is 34 times larger than the actual data stored in it. A little overhead, yeah, but ...
0
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34159541
the thing is... there's no way to make that size smaller... unless it's reducing the content or shrink the db file.  there's not another tool that magically compresses the size of the file.

imo, M$ may have planned some overhead.... in order to make SQL Express a less viable option.
0
 

Author Comment

by:JonFleming
ID: 34159644
32 times overhead? Even the Evil Empire wouldn't do that. I bet if I restored one of my backups into a new database that database would be very small ...
0
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 34166526
the point is that there isn't a way to "change" that unless you shrink the db or remove content.  you can't magically make the size smaller.  it is what it is.

if it were a log file, the story would be different.
0
 

Author Comment

by:JonFleming
ID: 34166534
Well, I'm going to try importing the baqckup into a new DB. Just to see.
0
 

Author Comment

by:JonFleming
ID: 34175789
OK, I did some more investigation and it turns out that the log file is the size issue. What I thought was automatically shrinking the log files wasn't shrinking them. I tried shrinking the log files but they won't shrink because the initial size of the log file is 4,529MB. From "DBCC SHRINKFILE (ShareWebDB_log, TRUNCATEONLY)" I get "Cannot shrink log file 2 (ShareWebDb_log) because of minimum log space required.". From "DBCC SQLPERF(LOGSPACE)" I get 1.4% of that space being used. T I've tried a lot of variations and nothing seems to affect the size of the log file. I can see the initial size in the database properties, and I can change the number, but when I click OK the change is lost.
0
 

Accepted Solution

by:
JonFleming earned 0 total points
ID: 34198591
Finally fixed the log file size. I removed ShareWebDB as a content database in SharePoint 3.0 Central Administration. In SQL Server Management Studio I created an empty database named ShareWebDB2. I used DBCopyTool to copy ShareWebDB to ShareWebDB2 (which just did a backup of one and a restore to the other). THe resulting database had a small initial log file size and a small log file size. I then attached ShareWebDB2 as the content database for my SharePoint site, and Bob's your uncle.
0
 

Author Closing Comment

by:JonFleming
ID: 34224629
Figured it out on my own.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

738 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