Link to home
Start Free TrialLog in
Avatar of tonyjohn65
tonyjohn65

asked on

SBS2011 Event ID 1105 and 1827

My SBS 2011 server has thousands of Application Event IDs of 1105 and 1827.  

Event ID 1105, MSSQL$SHAREPOINT - Could not allocate spase for object 'dbo.MSSBatchHistory'.'D(_MSSBatchHistory' in database 'WSS_Search_SBS2011' because the 'PRIMARY' filegroup is full.  Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Event ID 1827, MSSQL$SHAREPOINT - CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative databasesize would exceed your licensed limit of 10240 MB per database.

What is the best way to resolve this?
SOLUTION
Avatar of Perarduaadastra
Perarduaadastra
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tonyjohn65
tonyjohn65

ASKER

I believe it is SQL 2008.  When I open SQL Server Management Studio I can see the SBS2011\SHAREPOINT (SQL Server 10.50.2500)
It is, but the Express version! You only get the full version with SBS 2011 as part of the Premium Edition.

Be aware, if you do upgrade, that you may need to get another server to run it on, and you certainly will need a Premium CAL for each user that connects to the database...
We don't even use sharepoint.  Is there a way to clean this database up?
Also, when I look at the size of the master database under properties and General it looks like the database is only 4.7MB in size.  Am I looking at the wrong database?
Here is my screen shot.
SQL.PNG
This is looking a bit odd...

Your master database size is 4.75MB, as you say, but the available space is only 1.27MB! Where is this database being stored? Also, its creation date appears to be over nine years ago!

Event ID 1105 refers to WSS_Search_SBS2011 - how big is that one?
That's the one.  10385.44 MB.
I think that this is a log file issue. The database itself may be tiny, but those log files just keep on growing...

There's a step-by-step here:

http://ali.vg/2011/03/sharepoint-config-database-log-file-too-big/

which you may find useful; however, as always, make a backup before doing anything you might regret later...

Also, this article explains the need for active and planned maintenance of these databases:

http://geekswithblogs.net/RogueCoder/archive/2008/06/03/122588.aspx

... and although it deals with SQL Express 2005, the principles are the same.
Can I do this Shrink File with the Empty file by migrating checked?
I'm sorry, I don't understand the question.
When I look at shrinking the log files, they are showing that they are only about 2MB.  Shouldn't I be shrinking the database?
Is the database itself that's so big? If so, it might be as well to find out what's in it. If your organisation isn't even using Sharepoint, then what is?

The links I provided above were on the (perhaps incorrect) assumption that it was uncontrolled growth of the log files that was eating up the space. If the database itself is 10GB in size then what information is being stored in it, and what is generating that information?

What is the extension of the 10GB file?
WSS_Search_SBS2011.mdf
Well, that certainly seems to be the database file...

I have no clue as to why it's so big, particularly as you say that Sharepoint isn't used at all.
I wonder if it is being used, but not in a way that makes users aware that Sharepoint is the shaker and mover behind the scenes, making it all happen.

I must confess that I'm beginning to get a little out of my depth here; I haven't yet worked with Sharepoint 2010 Foundation, though the day isn't far off. However, I did find this on Microsoft's site:

http://www.microsoft.com/en-us/download/details.aspx?id=24282

... and it does have a section on shrinking the database...
Avatar of Jeffrey Kane - TechSoEasy
If you've recently patched SharePoint, please review this article:
http://blogs.technet.com/b/sbs/archive/2011/05/24/you-must-manually-run-psconfig-after-installing-sharepoint-2010-patches.aspx

Jeff
TechSoEasy
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for your direction Jeff!