Backing up your database for Kennel Connection 6

Backing up your database for Kennel Connection 6

We strongly recommend that you backup your database regularly.  We have supplied a backup/restore utility within your software to aid you in the safekeeping of your data.  For Microsoft Access databases, the file that contains your data is named WKENNEL.MDB and is stored in the KC6 folder on your main computer (where the database is housed).  For SQL databases, the file that contains your data is called WKENNEL.MDF and also has a separate log file called WKENNEL_LOG.LDF and these files can be stored in the KC6 folder or the C:\Program Files\Microsoft SQL Server folder.  If you do not choose to use the backup utility provided by us, these are the files you must copy and save.  


IMPORTANT:  Software Connection cannot and will not be held responsible for lost or damaged data.  It is your responsibility to backup your data.  A utility has been provided with your software to aid in the backup of your data.  If you need assistance with this utility, please do not hesitate to contact technical support.  Support@KennelConnection.net or 1-888-486-4343 x 504.


For restore instructions, click on Restoring your database to a new computer


It is highly imperative that you back up your database at least once a week.  However, backing up daily is ideal.  Just remember that if your computer crashes and it has been a week since your last backup, that's how much data will have to be recreated.

The only method we support is the Backup/Restore utility found on your computer.


Click on Start, All Programs, Kennel Connection 6, Backup/Restore utility.


Windows 8 Users:  The Backup/Restore Utility is located on your "Start Screen".  If you cannot find it there, move your mouse to the upper right hand or bottom right hand corner of your screen to bring up the Windows 8 Charm Bar.  Choose the search option and type in "backup" without the quotes and choose the proper Backup/Restore Utility option.


 



Windows 10 users

‚Äč

To find the Backup/Restore Utility, find the "Search the web and Windows" bar by the Start button on the lower left hand corner of the screen circled in red below  Type in Backup Restore.  The correct option is highlighted below.



Backup Restore



Online backup programs can sometimes work, but if the database is in use in any way, shape or form, it cannot be backed up.  It will back up the name of the database (wkennel.mdb) but none of the data will be there.  Too many times, we have logged in to help a customer restore their data from an online backup program and when we search for their backup file, it's just the name of the file and no data.  These clients are then forced to start their database from scratch.  Don't let this happen to you!


Using the backup/restore utility


The Backup/Restore utility provided with your software will, for Microsoft Access databases, compress your data into a zip file and store it to the drive you select.  For SQL databases, it will create a .BAK file and store it on the drive you select.  It does offer you the option to also create a zip file.  The backup utility does not compress a SQL database.  As you use your system, your database file will grow, resulting in the possibility that you may eventually need larger storage medium to hold the backed up file.  Typically, the system will compress your file to appromixately 1/10th of its regular size.


To backup:


1.  Kennel Connection must be closed on all computers.  This includes the timeclock.exe and BCSLive.exe.  Go to your main computer where the database is.


2.  Click on Start, All Programs, Kennel Connection 6, Backup/Restore utility.


3.  Click on 'Backup the database' tab.  Choose the drive you want to backup to with the arrow keys.


Please note:  We strongly recommend backing up to an external drive or flash drive.  When you plug the drive into your computer, it will pop up a message and tell you what drive letter it is using.  Choose that letter with the arrow keys.  If it does not pop up and tell you, open 'Computer' or 'My Computer' to find the drive.


4.  Always leave a check mark in the box that says 'Compact/Repair' as this will compact your database, getting rid of unnecessary files that slow down the software, and will also repair it in case there are underlying issues.


Please note:  There is no Compact/Repair checkbox for SQL users.


5.  Press 'Backup the Database' button at the bottom.



Backing up the database



You have just made a backup copy of your database.  

  • Access backups are called KC6Date.zip, or KC606202013.zip, for example.  You may not see the .zip extension.
  • SQL backups are called KC6Date.bak, or KC606202013.bak, for example.  You may not see the .bak extension.

Please note:  If you do not have a flash drive or external drive, depending on your Windows user rights, you may be able to choose your C drive.  This will put a backup file on your local hard drive if you have the correct permission to write to that drive.  Please understand that if your local hard drive crashes, you will also lose this backup file.  If it does not allow you to write to your C drive or it does backup to your C drive but you do not see a backup file there, it is a local permission issue.  You will need to contact a local technician for assistance or use a flash drive.


Important Notice:


 Kennel Connection gives you the ability to attach Pictures or Documents to pet/owner records.  These files are stored in the KC6 folder on your main computer (where the database is housed).  The Backup/Restore utility does not back up Pictures or Documents folders.  If you use these features in Kennel Connection, you will need to copy these files separately onto your flash drive or external drive.  One is called Pix, the other is KCDocs.  If you are not sure if you use these features, open the Pix and KCDocs folders.  If there are files within, you need to copy these folders onto your flash drive periodically.  Depending on how often you add to these folders, you can do this weekly or more often.  


If you process credit cards through Kennel Connection, or have clients sign receipts with the signature pad, a copy of that receipt is put in the Receipts folder.  This folder is not backed up with the Backup/Restore Utility.  If you use this, you will need to copy these files separately onto your flash drive or external hard drive.  The folder is called Receipts and is found in the KC6 folder on the main computer (where your database is housed).  If you are not sure if you use this feature, open the Receipts folder.  If there are files within, you need to copy this folder onto your flash drive periodically.  Depending on how often you add to this folder, you can do this weekly or more often.



pictures documents receipts

    • Related Articles

    • Backing up your Kennel Connection database

      Backing up your Kennel Connection database Backing up your Kennel Connection 7 database We strongly recommend that you backup your database regularly.  We have supplied a Backup/Restore utility within your software to aid you in the safekeeping of ...
    • Creating a database backup

      Creating a database backup If you're looking for instructions on how to upload your database to support, click here: Uploading your database to support Creating a database backup is easier than ever. (Must be on KC version 7.07.18 or newer for this ...
    • Installing an update to Kennel Connection desktop

      Installing an update to Kennel Connection desktop If Kennel Connection posts a new update and you'd like to get it installed or you have been advised by a support representative to install the update, please see the instructions below.  Requesting ...
    • Error 503 when backing up the database

      This error occurs when you are trying to backup Kennel Connection to a CD drive.  Kennel Connection is not a CD burning program.  You will have to back it up to the C drive and then use a program to burn it to a CD This error can occur if you are ...
    • Kennel Connection 7 Upgrade Instructions

      Kennel Connection 7 Upgrade Instructions Important:  This document contains the instructions for upgrading your Kennel Connection 6 software to Kennel Connection 7 for DEMO or FIRST TIME KC7 users only and in no way pertains to current Kennel ...