Insufficient database space in EHP 5.0 process

[Former Member]

We are in process of EHP 5.0 upgrade on our Quality Server.The operation has stopped in Check phase of installation.The error message reads 'insufficient database size'.Quality system total database partition size is 271 GB and free space available is 109 GB. Occupied SAP database size is 152 GB and 10 GB allocated for virtual memory.

Autogrowth option was already enabled in database properties. Autogrowth column shows By 100MB unrestricted growth.

SAP server is running on Win 2003 platform.

Error Log

ERROR> Insufficient free space in the database as follows:

IN DATABASE Q07

---> Make sure that you have 139668 MB freespace available

---> in the database Q07

INFO> Please note the following considerations to increase your database:

---> Disk space usable for autogrow: 112043 MB

---> Calculated freespace in database Q07: 4982 MB

IF OPTION AUTOGROW is SET:

Please make sure that you extend the disk space available

to the database by 22643 MB

IF OPTION AUTOGROW is NOT SET:

Please make sure that you extend your database by 22643 MB

Our database is MSSQL.Shrink database option does not release much space.

Could you please help to suggest an appropriate solution to our issue.

[former_member188883]

Hi,

IN DATABASE Q07
---> Make sure that you have 139668 MB freespace available
---> in the database Q07

Is it possible for you to add Hard Disk on your system. By doing this you can create a new data partition and add a new datafile in that partition. This way you provide space for db growth .

Hope this is useful.

Regards,

Deepak Kori

[Former Member]

Hi,

Increase your database size. To do that check the following link:

http://technet.microsoft.com/en-us/library/ms175890.aspx

[former_member184473]

Hi Punit,

As mentioned before, you basically need to increase your database size.

Check the following whitepaper for further information about MSS Performance:

http://www.sdn.sap.com/irj/sdn/mss?rid=/library/uuid/4ab89e84-0d01-0010-cda2-82ddc3548c65

Regards,

Eduardo Rezende

[Former Member]

The message indicates that you need more disk space for the drive where the database files are located, than you currently have physically available.

You could move those database files to a different drive on that server if you have a larger drive available then try again. If not, then you would need to add more drives, either in the form of extra disks, or as a separate external array on a direct cable connection or through a SAN. (It will depend entirely upon what hardware you are using, and the capacity to increase it)

We've added external arrays very successfully in the past. It's not too difficult, but it does take a bit of time.

[Former Member]

Hi Punit,

This seems a critical situation, as in Windows platform it is not easy to extend the disk partition to a bigger size. However, nowadays I have heard of adding more disks to the windows host dynamically but not sure it will resolve your issue of the 'current' disk partition.

As the message suggests, you need 20-21 GB more on current disk partition to make the total free space available to 139668 MB. Try to talk to your Windows team if something can be done to extend this existing partition itself...or if they can attach any removable disk here for temporary time period.

Another thing, nowadays, in MS SQL Server 2008 R2 I think, you can go ahead for database compression as well. I haven't gone through this note yet, but you try to see if something is possible.

Note 1488135 - Database compression for SQL Server

Rest, see if our other colleagues can help us here.

Thanks