I have a 40 GB progress database on my server and only 70 GB of free space. I need to free up some space on the disk, are there temp files stored some place that can be deleted.
Take a look at the ‘Database Purge and Summarize’ program under System Mgmt > Utilities. You can use it to purge using a date range on certain types of data within Epicor like Change Logs.
Hate to be that guy… but… buy a bigger hard drive? 70 GB isn’t enough to run any production system on. Virtualization is also your friend right @EarlGrei ?
Progress did have temp files too.
What are the temporary files used by the OpenEdge client? - Progress Community (force.com)
Yes @josecgomez the level of ease in uplifting to a virtual hosting environment such as HyperV is such that it does not make sense not to. Backup and restoration becomes easier. Resource allocation and upgrades becomes easier. RTO/RPO goals become much easier to handle. I have successfully converted physical servers to VMs for every Windows server OS back to Server 2003 using the freely available tools on the market now. If a limiting factor of your platform is because you are stuck at 70GB then you should absolutely be exploring a hardware refresh and upgrade to HyperV.
There is actually 300 GB total capacity on the disk, but the Epicor905 EpicorData folders are using 180 GB of storage.
ohhhhhhh the EpicorData folders can usually for the most part… be cleaned out. What’s on there that is so large? Epicor Data folder is suposed to be temporary data.
here’s an old script we used to clean up this EpicorData folder
:: Will scan the directory and delete any file older than XX days
:: The xx being whatever value comes after the -d flag
:: Clear General EpicorData files generated by the server
forfiles -p "C:/Epicortemp" -d -15 -m Assign* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -1 -m baq* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -15 -m bfc* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -15 -m bpm* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -15 -m BusEntity* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -15 -m COAL* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -7 -m DBI* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -15 -m GLBCOA* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -15 -m GLJrn* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -7 -m lbi* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -5 -m rcd* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -15 -m RestrictFcts* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -15 -m srt* -c "Cmd /c del Echo @Path"
forfiles -p "C:/Epicortemp" -d -15 -m trp* -c "Cmd /c del Echo @Path"
:: Clear User Specific files that linger by user
forfiles -p "C:/EpicortempReports" /s -d -90 -m *.xml -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicortempReports" /s -d -90 -m *.txt -c "Cmd /c del Echo @Path"
:: Clear User Specific bat files that linger by user
forfiles -p "C:/EpicortempReports" /s -d -15 -m *.bat -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m Assign* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -1 -m baq* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m bfc* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m bpm* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m BusEntity* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m COAL* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -7 -m DBI* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m GLBCOA* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m GLJrn* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -7 -m lbi* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -5 -m rcd* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m RestrictFcts* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m srt* -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorData" -d -15 -m trp* -c "Cmd /c del Echo @Path"
:: Clear User Specific files that linger by user
forfiles -p "C:/EpicorDataReports" /s -d -90 -m *.xml -c "Cmd /c del Echo @Path"
forfiles -p "C:/EpicorDataReports" /s -d -90 -m *.txt -c "Cmd /c del Echo @Path"
:: Clear User Specific bat files that linger by user
forfiles -p "C:/EpicorDataReports" /s -d -15 -m *.bat -c "Cmd /c del Echo @Path"
Note you’ll have to change your paths
And sometimes you can recover some disk space by trucating the BI file for your Progress database(s)?