SQl Server Database Refuses to grow .

[jackal121865]

I have created a new database on an existing Sql Server 2000
standard edition install. When I attempt to import a file into it. I receive the following error.CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database.
Unable to find any information about this. Any ideas what the issue is?

 

[SQLSister]

Are you sure you are using standard edition? This is from Books Online:
The size of a database cannot exceed 2 GB when using the SQL Server 2000 Desktop Engine or the Microsoft Data Engine (MSDE) 1.0

Sounds like you are using the MSDE to me.

 

[SQLBill]

I haven't confirmed this, but I believe you are also limited to that size if you are using the EVALUATION edition.

-SQLBill

 

[aleeza]

I believe you have restricted the size of this database to 2GB.
Follow is procedure below to fix this error;

Right click the database and select the properties.
Then Select the data files tab.
GO To File properties and check the Automatically grow file
and select the file growth By percent as 10%.
And rerun the import job.
It will resolve this issues. And check the empty space of your drive.

Please let me know...