Solved

Event ID 1827

Posted on 2014-04-12
7
765 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
  • 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
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 

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 9

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now