on 10-05-2011 9:04 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Increase your database size. To do that check the following link:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.