Archiving the database (and restoring) - Repairing at bottom of page

The database gets slower the more call data is stored, and will collapse completely if the database is allowed to reach 1 gig in size. If the database is ever allowed to reach 1 gig then it is rendered useless and the only course of action available is to remove it and download an empty database from the Downloads page of this site and start over.

Reports will alert you that you have reached the desired database size limit (determined by your settings in Reports>Maintenance>User Preferences>Database) and we strongly recommend an absolute maximum size of 500meg.

Archiving extracts old call data from the database and stores it in a compressed back up file ready to be restored into the main database if ever needed.

Archiving procedure


Step 1

Close all PABXSoft programs down including Reports, Call Collector/Call Collector Service.

Step 2
Browse to the PABXSoft folder on the Call Collector computer where the database is located (normally My Computer>C:\Program Files\PABXSoft) and then open Call Collector folder and then the Data folder.

Locate the pabxcalls.mdb file and right click on it and select COPY

Then right click somewhere on the screen and select PASTE and wait for a copy to be created of your database.

This is a back-up of your database in case anything should go wrong during archiving. It will be called copy of pabxcalls.mdb and if the archive goes wrong, you can delete the pabxcalls.mdb database and rename the back up as pabxcalls.mdb.

Step 3

Go up a couple of levels until you are in the main PABXSoft root folder and open the Reports folder. Locate the file called Archive.exe and double click it. Select a date range of old call data you want removed (be careful not to include very recent data) and a location and file name for the archive (e.g. create a new folder in PABXSoft called Archives and the file name might be July-Dec 2012). When ready, click Archive and WAIT>>>>>>>>>>>>Do not under any circumstances interrupt the process, end task or anything like that, until it is finished otherwise you WILL corrupt the database.

Normally, the archive will take less than 5 minutes but on a very large database on a slow machine, it could take over an hour.

When complete, you will get a 'Archive Complete' message

TIP
We suggest that if you are archiving data that spans multiple months and years that you do a series of smaller archives rather than one great big one. e.g. Jan-Jun 2011, July to Dec 2011, Jan-Jun 2012 etc

This will allow you to refine how much data you restore to the database if you ever need to.

If it doesn't work...
We have prepared a document describing how to achieve an Archive if the standard method does not work for you.

If you follow it very carefully it usually works. If all else fails, note the link at the end of the document to Office-Fix.

Click here

 

Restoring from old archives.

1. Close all PABXSoft applications and services (Call Collector, Reports, Scheduler etc)

2. Browse to the PABXSoft folder (normally C:\Program Files) and then open the Reports folder. Locate the file called Restore.exe and double click it.

3. Click on the browse button opposite the label 'Archive Location' and browse to the old archives folder

4. Double click the archive you want to restore and wait until you get a 'Restore Completed' message

5. Close the restore program or repeat to import more archives, and then re-start whichever Call Collector you were running.

 

Repairing a corrupted database - click this link

 

 

 

 

 

 
 
Home  |  FAQ's  |  Downloads  |   Contact Us  |  News