Solved

Event ID 1827

Posted on 2014-04-12
7
855 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 350 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
Independent Software Vendors: 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 150 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

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 with K2 5 33
Sharepoint data after Hyper-V restore 4 37
lock down downloads folder 8 94
aes256 Ransomware on SBS 2011 13 75
Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
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...
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 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