img

Spring clean drive C:\


Databases are great things, they allow us to easily grab data and display it in many formats, the bad side, of course, is that sometimes a database can get a little upset.

A full disk or any sort of disk corruption such as those caused by power outages or unexpected system shutdown/failures can corrupt a database.

So to ensure PaperCut lives a long and happy life on your server make sure PaperCut has enough room for the database to grow.

JAM Software offers a great bit of software called Tree Size that will show you where that missing disk space is, you would be surprised at the junk that collects in temp folders.

So if you have ignored all the warning signs from your operating system and have corrupted the PaperCut database what do you do? First up do not panic and secondly read on…

How do I restore a PaperCut database if the database is corrupted?

You will need at least one good backup file from the backup directory [app-dir]\server\data\backups\. To restore the database follow the instructions below.

Spring Clean

 

 

Option 1 – restore via your own backup software


If you have an off disk backup, simply:

Stop the PaperCut Application Server service (Control Panel->Admin Tools->Services), or run the stop-server script in [app-dir]server/bin[platform] if running on Linux or Mac.
Restore all files and folders located at: [app-dir]server/data/internal

 

Option 2 – restore using one of PaperCut’s point-in-time backups


  1. Login to the PaperCut server.
  2. Stop the PaperCut Application Server service (Control Panel->Admin Tools->Services), or run the stop-server script in [app-dir]server/bin[platform] if running on Linux or Mac.
  3. As a backup, take a copy of the [app-dir]server/data/internal directory.
  4. Open a command prompt (cmd.exe).
  5. Change to the [app-dir]server/bin[platform] directory. e.g. cd “C:Program FilesPaperCut NGserverbinwin”
  6. Run the following command to re-initialize the database: db-tools.exe init-db -f
  7. Then restore your backup into the database by doing the following (changing the backup file name as appropriate)
    db-tools.exe import-db “C:/Program Files/PaperCut NG/server/data/backups/export-2009-05-10T00-20-03.zip”
  8. Once completed, restart the application server service.
Latest News from Nick Kean
img

Drivve Image v8

Premium scanning solution Drivve Image is now on version 8. Drivve Image v8 h...

Written by: Nick Kean

More
img

PaperCut High Availability

Clustering and PaperCut high availability are popular topics in our regular dis...

Written by: Nick Kean

More

img

Having dealt with Selectec for the past 8 years the service and support we get for PaperCut MF has been exceptional, support requests are met in a short timescale and dealing with the friendly and knowledgeable staff is always a pleasure

Phil Kelly Midshire Business Systems
This website works best using cookies which are currently disabled. We use cookies to help with our site analytics to improve our services.
Back to Top ↑