I am new to Bacula. I have around 10 linux servers (all centos - various versions) and couple of windows servers.
Goal: Backup all data (files and databases) from these servers to a central location over internet in a secure way at predefined interval, and should be able to restore fully or partially when required.
Resources I have: Backup server with Centos 6.4 HDD with enough space to backup all clients. I am not using any tape drive, but doing a remote backup of clients to an HDD on my backup server
What I understand on secure backup with Bacula:
1. I can use combination of Bacula and stunnel to securely run bacula backups
It is possible but very complicated compared to Bacula TLS. My recommendation is not to use it.
2. Or I can use TLS encryption on Bacula without stunnel
Recommended option.
Configurations I did:
1. I was able to successfully install and configure bacula on my backup server and one client. The backup is running fine on scheduled interval
2. I have installed stunnel, ssl certificates, but it doesn't seems the data is transfering through stunnel
Drop it, it is a dead end. Use Bacula TLS.
What help do I need:
1. Configure stunnel and bacula in a way that the data transfer is through stunnel
Do you try configure a Bacula TLS?
2. How do I browse through the files I backed up?
Use restore command in bconsole or any gui. Or you can list all files backed up with list files jobid=xx command.
Can I loop mount? (bls shows the contents, but I am not able to find a specific file from specific location with this command)
What does it mean "loop mount"? Do you want to perform an archive volume file mounting using loop device in Linux/Unix, something like mounting iso image? If so, it is not possible.
3. How can I have each of my client has separate backup images/folders
Define dedicated storage device for every client. It is simple but with more clients it is very hard to manage.
4. How can I backup MySQL db from linux servers and MSSQL from windows
Personaly I use mysqldump for MySQL and VSS Plugin from Enterprise version for MSSQL.
5. How do I do a partial restore (or single file; I don't know the filename but know the location)
Use restore command and browse all required locations.
6. How do I configure my windows client to backup using stunnel
Use Bacula TLS.
Most of the links I found over internet specifies configuring only one client. I couldn't find a proper guide to configure a second client.
In the same way like the first client. It is useless (IMHO) to prepare a howto/inctruction on how to configure Bacula with 2 or 41 clients, because it is the same like for only one.
Any help on this (step by step instructions or links to guide or the steps you followed while installing) is greatly appreciated.
All you need you can get from documentation and your own testing.
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html