Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Space problems with the SAP Database MS SQL 2000

Hi,

Actually, I have a size problem with the database, I have MS SQL Server 2000 with Service Pack4 on a Windows 2003 Server environment that is my DataBase Server of my ERP ECC 6.0. On the other hand I have a storage where I have 229 Gb of free space used only for the database files of the SAP data and the SAP log file.

But when I check the DB space allocation on trx. DB02 I saw this:

3 Database files and 1 transaction log:

The 3 database files are: PRDDATA1 (size 15,313 MB used 15016 MB) , PRDDATA2 (size 14106 MB used 13984 MB), PRDDATA3 (size 14472 MB used 14352 MB) and the log file is PRDLOG1 ( size 1000 MB) all of them with no limit option and growth by 10%.

So I went to the SQL Enterprise Manager and I saw that my Database PRD properties and I got this information:

My database size is 44892.48 Mb size with only 1330.36 Mb of free space and that is alarming.

So the question here is how ,if I have a storage where the sap data is storing with 229 Gb of free space, can I make the database files grow up in order to use all the available space of my storage.

Can you help me please because it is critical being my productive system?

Best Regards

Erik Espinosa

Former Member
Not what you were looking for? View more on this topic or Ask a question