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(_ MSSBatchHi story' 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?
Event ID 1105, MSSQL$SHAREPOINT - Could not allocate spase for object 'dbo.MSSBatchHistory'.'D(_
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...
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...
ASKER
We don't even use sharepoint. Is there a way to clean this database up?
ASKER
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?
ASKER
Here is my screen shot.
SQL.PNG
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?
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?
ASKER
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.
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.
ASKER
Can I do this Shrink File with the Empty file by migrating checked?
I'm sorry, I don't understand the question.
ASKER
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?
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?
ASKER
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...
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...
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your direction Jeff!
ASKER