Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Event ID 1827

Posted on 2014-04-12
7
Medium Priority
?
947 Views
Last Modified: 2014-04-29
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
Comment
Question by:citrine
[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
  • 3
  • 3
7 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 39996825
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
 
LVL 29

Accepted Solution

by:
QPR earned 700 total points
ID: 39996827
0
 

Author Comment

by:citrine
ID: 39996837
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:citrine
ID: 39996839
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
 
LVL 29

Expert Comment

by:QPR
ID: 39996843
"SharePoint foundation Search" is the help search
"Sharepoint server search" is the main search

Assuming you are using sharepoint server.
0
 

Author Comment

by:citrine
ID: 39996857
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
 
LVL 10

Assisted Solution

by:Mohit Nair
Mohit Nair earned 300 total points
ID: 39998479
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

704 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