How do I back up my database?
Remember that if you are using our cloud hosting service, the Societ team backs up your database every day. If you need a copy of this backup, give us a call or email support@sumac.com!
All versions of Sumac have a Backup Entire Database tool which will save your database as a .zip file which you can save to the location of your choice.
Step 1. Start by navigating to Utilities under the main Sumac console. From here expand Sumac Administration.
Step 2. In here you will see a button called "Backup Entire Database." This is the button which will allow you to do just that, remember that if you are not an administrator, you will not be able to see this.
Step 3. When you open Backup Entire Database, the first thing you will have to do is click Choose File. This will allow you to choose the name of the file and where you want to put the backup file. After choosing the name and location click OK and it will backup the entire database.
You should put the backup file to a type of media that is not in the same location as the computer being backed up. This can be removable media like a USB key, a writable CD or DVD, a remote backup server, or an external hard drive. If you put your backup on relatively unreliable devices (e.g. CD-R or DVD-R), then make sure that the backup program verifies the data after writing it.
Once the backup is performed, remove the media. This does not mean to just turn it off or disconnect it from your computer. You need to physically remove it from your office. If you just put the backup device into a drawer beside the computer being backed up, then the same disaster (flood, fire, theft, lightning, etc.) that destroys the server computer will probably also destroy the backup device.
You should have multiple copies. Don’t just back up to one device and re-use it every week. We recommend at least five different backup devices, using a different one each week on a five week cycle. Like any other electronic equipment, they can fail. Having just one or two is not sufficient.
Instead of physically removable media, you could also use an online backup service, which sends your data to a remote server.
Now you have an entire backup of the database which can be used to reproduce your database when needed.
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
Does Sumac have a backup of my database?
If you are using Sumac's cloud hosting service, yes, the Societ team backs up your database for you every day! If you need access to a backup of your database, or require assistance in restoring a backup, contact our team for assistance ...What is the backup process for my Sumac database?
When your Sumac CRM is hosted on our cloud service, we take care of backing up your database for you automatically. The Societ Team creates a backup of your database once a day. These backups are encrypted, and we retain daily data backups for 30 ...When I run Sumac, it tells me it cannot connect to the database server… why?
This message means that for some reason Sumac is unable to establish a connection to the database server computer. Single-User Sumac (Trial, Bronze, Silver) If you are running a single-user version of Sumac, the data is on your computer, so this ...How to connect to your cloud hosted database
Step 1: Install Sumac To install Sumac, follow the install instruction here on the Silent Partner Software website. Step 2: Find connection information This would have been sent to you in an email. You will need: Organization name OR Organization ID ...Why are special characters not saving in my database?
By default, the back end of your Sumac database holds characters in a certain way. The choice of language that Sumac chooses to record these characters is called “encoding”. Historically, Latin-1 encoding has been the best language to use for storing ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.