Microsoft SQL Server, Error:1827 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Microsoft SQL Server, Error:1827

I have installed SqlServer 2005 evalution version. The file size is now 4035. When I tried to add new data file name,I am getting the below error.
Pls can any one help me. Alter failed for database ‘test’. (Microsoft.SqlServer.Smo) An exception occured while executing a Transact-SQL statement or batch(Microsoft.SqlServer.ConnectionInfo) Create DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database (Microsoft SQL Server, Error:1827)
doesnt the error is self explanatory?
Roji. P. Thomas
SQL Server MVP
http://toponewithties.blogspot.com
But in Sqlserver 2005 evalution version there’s no restriction on the size. But Still Iam getting this problem
What OS, sp and disk do you have?
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Stil the limit si applicable, andthe database will stay available and not corrupted… you just will not be able to insert additional data.` Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
No where mentioned about the db size limited 4GB for evaluation editon…Only Express Edition has 4 GB limitation is documented… Please post the output of the following…if it returns EE Evaluation then db size limited to 4 GB and not documented… SELECT SERVERPROPERTY(‘productversion’) AS [ProductVersion]
SELECT SERVERPROPERTY(‘ProductLevel’) AS [ProductLevel]
SELECT SERVERPROPERTY(‘Edition’) AS [Edition] MohammedU.
Moderator
SQL-Server-Performance.com
I might check that again on Evaluation edition part, I vaguely remember it might be a cause. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>