Thursday, March 8, 2012

Cumulative database size limit

Hello all,
I have SQL 2000 SP 3 running on a Windows 2000 server. It used to be a
Desktop edition of SQL Server which we then upgraded to the SQL 2000
i.e. the SQL Server name is of the type: abcd\efg. I am trying to
increase the size of the database but it gives me the following error:
error 1827 create/alter database failed because the resulting cumulative
database size would exceed your licensed limit of 2048 MB per database.
We have checked with the vendor and they do not have any such
restrictions. Is this a SQL Desktop edition restriction? If so, this
database has already been converted to SQL 2000. Have any ideas?
Thanks,
Raziq.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Is it possible that SQL Server did not successfully get upgraded. You can
verify this by looking at the SQL Server errorlog. It will tell you the
exact version that you are running. If it does not say SQL Server 2000
Standard or SQL Server 2000 Enterprise Edition then it did not get upgraded
successfully.
Rand
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment