Skip to Content
author's profile photo Former Member
Former Member

Insufficient database space in EHP 5.0 process

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2011 at 08:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2011 at 11:55 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2011 at 11:31 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 04:51 AM

    Hi,

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

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 13, 2011 at 05:27 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.