Jesoba.com is launched, Click below image to access it

Jesoba.com is launched, Click below image to access it
Technology and Entertainment Blog

Error 1827 CREATE DATABASE or ALTER DATABASE failed

Title: Error 1827 CREATE DATABASE or ALTER DATABASE failed

Product Version: SQL Express Edition

Event ID: 1827

Event Description:
=============

Log Name:      Application
Source:        MSSQL$SHAREPOINT
Date:          4/1/2012 12:08:18 PM
Event ID:      1827

Task Category: Server
Level:         Error
Keywords:      Classic
User:          LOCAL SERVICE
Computer:      hero.png.local
Description:
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.

Solution:
=======

We have following two options to fix the issue.

- Clear database Log (ldf) file this should help reduce the total database file size.

- Take backup, remove SQL express edition and install SQL Server edition.

Keyword: error 1827, error event 1827, error 1827 mssql

Reference: N\A

Google+ Badge

About Author

My photo

I am Senior Server Expert and Professional Blogger.