on 10-06-2007 6:00 PM
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
I resolved this issue myself. Thanks for all your help.
Best Regards,
Erik Espinosa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.