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.examnotes.net ***
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.|||Hi Rand thanks for your response. It is SQL 2000. The errorlog is
listing it as version 8.00.760.
Any other ideas?
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||What is the output of select @.@.version and select serverproperty('Edition')
?
It certainly sounds like it thinks it's Personal/Desktop edition
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:OAuC1Gy%23DHA.2512@.TK2MSFTNGP11.phx.gbl...
> Hi Rand thanks for your response. It is SQL 2000. The errorlog is
> listing it as version 8.00.760.
> Any other ideas?
> Raziq.
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Hi Jasper,
You are right when I run the @.@.version it is coming back with the
desktop edition. But I did run the upgrade utility. Ok, what can I do
to make it the Enterprise Edition?
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||I would probably start from scratch by detaching all my user
databases.Script all logins and jobs and save all DTS packages as structured
storage files then uninstall the existing instance and do a clean install of
Enterprise Edition. If you want to avoid any login->user SID mapping issues
afterwards you can export the logins as detailed here
http://support.microsoft.com/defaul...b;en-us;Q246133
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:uJ%234kc7%23DHA.4060@.TK2MSFTNGP10.phx.gbl...
> Hi Jasper,
> You are right when I run the @.@.version it is coming back with the
> desktop edition. But I did run the upgrade utility. Ok, what can I do
> to make it the Enterprise Edition?
> Raziq.
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Thanks for your help Jasper.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!