meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
maintenance:db-backup [2023/03/15 16:16] – errollmaintenance:db-backup [2024/01/08 16:49] (current) – erroll
Line 1: Line 1:
 +===== Backup your databases =====
  
 +<note important>
 +It is **not** a good idea to include the FastManager Data Folder in any kind of //automated// backup process (like Carbonite), or a cloud-folder sync service (such as Google Drive or Dropbox). \\
 +Rather manually ZIP the databases, then move them to another folder and let //that// folder be included in the automated backup.
 +</note>
 +
 +\\
 +**Step 1: locate your "FastManager Data Folder"**
 +
 +This is the folder where your company database is stored, as well as various other files and folders that FastManager uses.
 +
 +  * Open FastManager and check in the lower-left corner of the program window, there you will see the "path" to where your main company database is stored.
 +
 +\\
 +{{ :setup:db_location.jpg?direct |}}
 +
 +<WRAP center round important 80%>
 +NOTE: \\
 +If the database location reads as: <code>MS SQL SERVER</code> then these instructions are not relevant. Please contact the helpdesk and let them know you have a SQL database.
 +</WRAP>
 +
 +
 +\\
 +Using Windows File Explorer locate that folder. In it you will find the following files:
 +
 +  * ''%%db.qdb%%''
 +  * ''%%catalogs.mdb%%'' (or it might be just ''%%catalogs%%'')
 +
 +And some folders, such as: 
 +
 +  * ''%%thumbnails_1%%'' 
 +  * ''%%upsshippinglabels%%'' 
 +  * ... and a few others.
 +
 +Here is an example:
 +
 +\\
 +{{ :faq:selection_032.jpg?direct |}}
 +
 +\\
 +<note important>
 +The most important file to have a backup of is ''%%db.qdb%%''.\\
 +This is the file which contains all your customers, orders, and everything else (except your catalogs and items, those are stored seperately)
 +</note>
 +
 +\\
 +**Step 2**
 +
 +Get everyone to close FastManager
 +
 +  * Right-click on the file: ''%%db.qdb%%'' and select //__Send To -> Compressed (zipped) folder__//
 +  * Repeat the process with the file called: ''%%catalogs.mdb%%'' (might be listed as just: ''%%catalogs%%'')
 +
 +\\
 +Now you should have 2 new files in that folder called: ''%%db.zip%%'' and ''%%catalogs.zip%%''. \\
 +
 +\\
 +{{ :maintenance:zip-dbs.mp4?720x432 }}
 +
 +\\
 +**That is your backup.**
 +
 +You can now upload these 2 files to your cloud service of choice, or to the link provided by our HelpDesk, if you need us to do maintenance on the database/s for you.
 +
 +
 +
 +----