Clear Speed Net databases (POSPCC&POSPCCBACKUP) in Post Office

To reduce the database size, we suggest the following: 

• Verify whether POSPCC.mdf file is huge or POSPCC.ldf. 
• Verify whether POSPCCBACKUP.mdf file is huge or POSPCCBACKUP.ldf.
• In case, if ldf file is huge, then try to reduce the size by clearing the log entries or taking daily backup of Transaction Log. 
• If mdf file is huge, then, please use the shrink databases utility available at 

ftp://ftp.ptcinfo.org/GeneralScripts/shrinkingDatabases/

• Please go through the Readme file and follow the procedure specified. 

In case the database file does not shrink, try deleting old data (say, more than six months), duly specifying the period of one month at a time, under 

Supervisor --> Tools --> Delete Old data. 

Note: Prior to deleting old data, please take backup of all Databases and preserve the same. 

For Flush and Delete Old Data issue, please do the following and check: 

• Download attached zip file and unzip it 
• Take full database backup of POSPCC and POSPCCBACKUP 
• Run POSPCC21082015.exl file using Meghdoot ScriptTool.exe 
• Run POSPCCBACKUP21082015.exl file using Meghdoot ScriptTool.exe 

Download

Note: 

1) Only for getting report of Performance of Postman, data is being retained for 45 days. 

2) Other data like bags closed, bags received, bags opened including articles data will be retained for 3 days only in main database to avoid timeout error and performance issues. As such, please use the selection "Selected Period" and input the From and To period for data flushing to avoid referred issue.