How to use Database Backup Module


#1

Backup Module is an Add On Module for SambaPOS. You can install it through SambaMarket.

When you install Database Backup Module it will add Database Backups link to Management > Settings section.

Since we don’t have any backups yet the main screen is empty.

Click Backup Database button to create your first backup.

You should see backup details on the list. New backups will appear on top of the list.

You can select a backup on the list and click Restore Database button to restore your backup.

Display Backup Location will start file explorer to display physical backup zip files.

###Settings

  • Database Name: Leave it empty for general use. This setting is useful if you need to create backups for a different Database other than the configured database.
  • Backup Location: By default SambaPOS will create backups under [MyDocuments\SambaPOS4\Database Backups] folder. You can change default backup location here.
  • Auto Create backups after work period ends: By default Backup Module will automatically create backups after work period ends. Alternatively you can disable this setting and use Create Backup action for advanced uses.
  • Migrate After Restoration: Enable this setting if you want to automatically migrate your backup to latest version after restoration completes.
  • ** Allow overwriting database files if database names does not match during restore:** By default Backup Module won’t allow restoration if backup database name does not match to your current database name. Enable this setting if you need to restore a backup taken from different SambaPOS setup.

###Other features

  • Storing backups locally is not a good idea. Better you can use a removable drive for storing your backups. We strongly suggest using Dropbox or similar free cloud disk services for storing your database backups. Most services supports local folder synchronization so when you create files under synchronization folder these files automatically synchronizes with your Dropbox account. Configuring Backup Location Setting to your Dropbox folder will be enough.

  • This module adds Backup Database and Restore Database actions for advanced uses. You can create triggers for hourly backups or you can use it with other actions such as Send E-mail to automatically send your backup files as an email attachment. When you create a backup you can access latest backup file name with {:BACKUPFILE} setting.

  • Installing this module on your server will be enough for most cases. If you are ending work period from another computer you can also install this module on that terminal for automatic backups.


Migrate/Import entire database from one SQL instance to another
Moving the program to other computer
How to save all the data to transfer to another computer
How i can backup samba v4 im using sql server 2012
Database Backup Module error
How to copy transfer data base to new pc
Samba Market is Open!
#2

This would definitely be worth buying to save time from backing up manually!

By the way, is this feature the same as SQL server management studio’s “Full Backup” option? and can I restore it on different machine?

Thanks in advance


[Resolved] Problem installing database tools and backup modules on multiple computers
#3

Yes it uses SQL Server’s backup mechanism so you can restore it on a different machine with Backup Module or SQL Server management studio.


[Resolved] Problem installing database tools and backup modules on multiple computers
Samba V4 giving error
#5

where is this option “Create Backup action for advanced uses.”


#7

Greetings EMRE i have an issue with restore a database to a new computer.
I have some photos for view errors. Please help me with this. Thanks!!! What I can do? I NEED RESTORE THE (CE) DATABASE TYPE. BUT THE (SQ) IS A SAMPLE DATABASE BACK UP. IS ONLY A TEST. I TRY SEVERAL TIMES RESTORE THE (CE) DATABASE. PLEASE HELP!!!
HOW CHANGE THE DATABASE TYPE?


#8

You can not interchange CE and SQ. You should convert your CE to SQL and use SQL. CE does not support many of the advanced functions and is quite frankly slow compared to SQ.


#9

Really how i make this convert. y have installed (SQL SERVER MANAGEMENT STUDIO) You have a tutorial that makes this convert?


#10

Yes there is a tutorial. Second half of tutorial explains how to convert CE to SQL Must click on the link if you just expand it inside this thread it will not show second half.

http://forum.sambapos.com/t/sql-express-2014-installation-sambapos4-database-setup/3363


#11

hello,
i’m sorry but I have ran into a problem and I just don’t know what to do. I uninstalled and deleted the sambapos4 folder from my documents and after reinstalling sambapos, the problem is still there.
When I try to do a backup, it just wont let me. I get error message:
Cannot open backup device
’C:\Users\Lu\Documents\SambaPOS4\DatabaseBackups\SAMBAPOS4_Full.bak’.Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally


#12

Common mistake but thats permission issue. You should not backup to users folder. These folders are protected by Microsoft you should backup to another folder outside users dir

Also uninstalling Samba does nothing. SambaPOS settings are stored in the database not the software. There are very few settings stored in the actual software. Additionally some settings are stored in a hidden folder under c:\ProgramData\SambaPOS


#13

Man that was simple. LOL
Thank you, you guys are great.


#14

@emre Was thinking today after looking at the backups directory that it would be nice to be able to configure some form of catalogue archiving for automatic end of period backups.
I think setting auto backup at end of day is a must for any install to ensure if anything happens you can jump back to 24hrs at the most.
However with this setting obviously the backups soon start mounting up and although you can obviously go in and take out older backups it would be one less thing to remember/do if there was a way/option to do say daily for a week, weekly for a month and monthly for a year or more or something like that.
I might be wrong but cant see an option nor can I cant find a post to do this as would imagine it would have to be a built in feature of the module.
would you agree @kendash
I think this would make a very nice addition to the module weather it be a module update or maybe option in v5.


#15

V5 has some additional features as I will demonstrate in a screenshot.

We discussed archiving and it was agreed that there is a benefit in it however we also felt that its not a pressing feature and we would rather see other features given more focus.


#16

@kendash description is a nice touch as would be good for labelling what was changed when programming new features.

Understand the focus on new features, very fair point, just thought id ask as couldn’t see the other post.
Just which I was more clued up with programming and coding as Samba is one of the few programs i’ve used and thought that I wish I could contribute more.


#17

What many don’t realize is by initiated good dialogs that is contributing in the best way. I mean good solid questions with supporting information and clear ideas with workflow helps this thing grow.

A good example is a few discussions me and @QMcKay have had started small and ended with 500+ threads and more than a dozen new features implemented. We may not even thought of those features if we had never simply started a conversation.

Also I just made a feature request in the beta forum specifically because of your question I may not have thought of it otherwise. So you are contributing simply by being active in discussions.


#18

:slight_smile: glad to have a little input lol

Quick one for you if I can? Can’t remember the thread you were involved in (not that there’s one your not ;-p) it was on but I’m sure a while back I read that a new feature in v5 was improved handeling with wifi (tablets etc) where the network connection may drop and reconnect… Am I correct? Is that a feature implemented?


#19

Yes there is a reconnect in v5 now.


#20

That’s a nice feature, very useful.
Presumably it would also come in handy should there be any sort of inturuption on network either wired or wireless.


#21

So I can make a backup action to backup every 5 minutes or so?


#22

That’s been possible for a while with database backup module. Yes you can.


Can you email the database backup