[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1046
  • Last Modified:

Event ID 1827

I have got this error on a STD 2011 SBS Server
The server is running and I'm wondering:

 a) if I need to attend to this error?
b) how to fix if the above answer is "yes"




Log Name:      Application
Source:        MSSQL$SHAREPOINT
Date:          4/13/2014 10:51:58 AM
Event ID:      1827
Task Category: Server
Level:         Error
Keywords:      Classic
User:          VISION\spsearch
Computer:      DCVISION.vision.local
Description:
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
0
citrine
Asked:
citrine
  • 3
  • 3
2 Solutions
 
QPRCommented:
Looks like you have a standalone install of sharepoint and are using sharepoint express.
This version of sql express has a DB size limit og 10GB and you have hit that limit
0
 
citrineAuthor Commented:
QPR ,

I cant find
All I had to do was log in to Sharepoint Central Administration and stop and start the Sharepoint Foundation Help Search.  This cleared out the database and my problem was solved.
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
citrineAuthor Commented:
This is as close as I can get....

    Open your SharePoint central Administration site
    Go to System Settings –> Manage Services on Server and click on Start against “SharePoint foundation Search”

But that's not the Help search
0
 
QPRCommented:
"SharePoint foundation Search" is the help search
"Sharepoint server search" is the main search

Assuming you are using sharepoint server.
0
 
citrineAuthor Commented:
When I click "stop" I on the "SharePoint foundation Search"
I get a message "The Microsoft SharePoint Search services that was
enabled on this server will be uninstalled and all index files will be
deleted permanently"
 
What are the repercussions of starting and stopping this service in layman's terms?
0
 
Mohit NairSenior AssociateCommented:
I think QPR is right. You have hit the database size limit. Move your SQL version from express edition to standard or enterprise.
Or else uninstall the search service by stopping it from central admin. Delete the Search database from SQL management studio. Start the search service again and give a new name to the database.But this workaround will not last for long.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now