Vembu Network Backup is one of the valuable features of Vembu BDR suite and its role is to perform backup and recovery for individual files and applications on Windows or Linux machines. In this post, I will be explaining about Vembu Network Backup features and how to configure backup and restore for MS SQL Application using Vembu BDR Suite v3.9.1 Update1 . Vembu Network Backup supports backup of MySQL databases tables with Full and incremental mode .Backup can be performed for MySQL databases even when the data is online and is still being accessible by other other applications.
Supported Operating Systems
|Windows Server 2008 ,2012 & 2016 (64-bit)||Red Hat Enterprise Linux 5 and later||10.5.x (Leopard)|
|Windows SBS 2003, 2008 & 2011||Debian Linux 5.0 and later||10.6.x (SnowLeopard)|
|Windows XP SP2 and above (64-bit)||CentOS 5.2 and later||10.7 (Lion) for Intel PCs & above|
|Fedora 11 and later|
|Ubuntu 10.04 and later|
Supported Microsoft SQL Version
Microsoft SQL Server 2016, 2014, 2012, 2008, 2005, 2000
Vembu Network Backup Features
- Backup and Restores Files /Folders
- Backup System State, Active Directory & Registry
- Backup and Restore Applications – MS Exchange, MS SQL Server, SharePoint and Outlook
- Backup and Restore can be managed from Single Console
- Encryption and Compression
- Disaster recovery
Refer Release Notes for Known Issues & Limitations
Configuring SQL Backup
Setup is running with below details
- Vembu – BDR 3.9.1 Update 1 Version
- Database – Microsoft SQL 2012
To configure the SQL backup first you have to download the Vembu Network Backup Client from BDR console
Login to BDR console Navigate to Backup -> Select Files and Application – > Download
Download the Backup Client from the available versions , here I am using Windows client
Run the downloaded Application
Click Next to Start the installation from Setup Wizard
Accept the License Agreement and Click Next
Provide the Network Backup ID and Click Next
Note :- You can add custom value for ID or default one which is Host Name or recommended option
Choose the Typical Option and Click Next
Note:- You my Choose Custom Option set the different configuration parameters
Click Install to start the installation on the Client Machine
Click Finish to exit from from installer and start the Network Backup Application
Since we selected Open the Vembu NetworkBackup Web Console it will open a console and you have provide the IP / Hostname and Click on Connect or You can connect the Network Console from Shortcut created on Desktop
Once Connected you can see message as Connected Successfully to the Server ( Hostname )
You have login to the Console with default username and password
From the Console navigate to Backup -> MS SQL Serer
Add the SQL Serer Instance and Click Next
Note:-You can use Windows Authentication or SQL Authentication , also don’t use sa user for configure backup as best practice create and use separate login for Instance or add Windows secured users with required permission ( backup administrator) .
You have different options for configure backup , this console will show all database and option available for backup .
Here I choose Select all Data Base and Click Next
Select the Schedule you need to configure , Select Backup Server , Retention period and Click Next
You have additional Scheduling options available , also you can configure custom Temporary Location for backup dumps and encryption , Click Next to Continue
Enter A Job Name for this and you can select the option to Run backup immediately after this backup configuration
Also you can review the configuration form same window and click on Save the Backup
From the Popup message click on Yes to complete backup configuration
You Can view the backup Progress by navigating to Backup – > List of Backup Jobs and Selecting Arrow From status option on the Windows .
Note : – After configuring the backup and ran the backup same time this window will open after the configuration completion step.
Restore SQL Database
Vembu Network has advanced options for restoring , find the below available options
- Restore directly to SQL Instance
- Restore to Custom Location
- Move the Restore Data from Custom Location to SQL Instance
Navigate to Restore and Select the backup job which you need to restore , in this scenario I am using SQL Backup Job
Click on Restore OPtion
Note :- You can choose Restore the data from Backup server or Previous restored data from Custom Location to SQL server
Select Restore data from backup server and Click Yes to continue
Select below details and select the Type of backup you want to restore by selecting check box then Click Next
- Database Name from Drop Down
- Show backups after – available backups taken after this period
- Enter the Location to Restore the Data
Next Select the appropriate option as you have to restore data to SQL Click Next
You will have two option to do same find below
Automatically Restore Data to SQL server database :-
This option will let you to restore data into SQL Server database, where you will have the option to either overwrite an existing database or restore as separate database.
Restore data to the Local Disk only :-
This option will restore data in a separate custom location instead restoring data into SQL Server.
Select the required recovery state option and Click Next to Proceed , you will have three options available
- Leave database in ready-to-use state by rolling back uncommitted transactions.Additional transaction logs cannot be restored (Restore with recovery).
- Leave database non-operational, and do not rollback uncommitted transactions.Additional transaction logs can be restored (Restore with Non-Recovery).
- Leave database in read-only mode. Undo uncommitted transactions, but save undo action in a standby file so that recovery effects can be reversed (Restore with Standby).
Note:- Password protected- If backup is password protected, enter the correct password to proceed with restore.
Note:- If you use Restore data to the Local Disk , only one option will be available for restore as shown below
Review the configuration and Select Restore Now to trigger restore
From the Restore this Backup Popup message , Click Yes to start the restore process
You can review the restore progress and verify restore completed .
Navigate to from Reports -> Restore Reports to check detailed verification of restore process by clicking on Job Name
Restore Report Start Time 3:20 Shows Automatically Restore Result and Start Time 23:13 shows the Restore Data to the Local Disk Only Result
More Vembu Pots
- Release notes 3.9.1 U1
- Vembu BDR Suite v3.9.1
- What’s New with Vembu BDR Suite Free edition
- Vembu BDR Suite Review
- Vembu Blog post