Our experts will guide you in setting up a backup and DR plan that actually works with the following steps:
webinars
Topic outline:
MS SQL Restore
Previously Restored Data
Restore Data from Backup
Time Stamp
Type of Restore
Recovery State
2. Now Click on Restore option and you can see available backup to restore.
3. Now there are two options given below:
a) Restore Data from backup server. And
b) I have previously restored data from my backup server to a local folder. I now want to use this data to restore the MS SQL Server.
4. Browse the previously restored data from the backup server to a local folder.
5. Select the data location of the folder or path to the folder . Click Ok.
6. Click on Yes.
7. Let’s select the first one to get an overview of this option “Restore data from backup server”.
8. Now select the below information:
a) Database Name.
b) Select Time Stamp.
c) Location of file.
9. We have selected the VIM_UMDB as the database name.
10. We have selected the the Time Stamp of the backup for restore.
11. We have the prompt with the Full Backup to be restored option. Select Full and click next.
12. After restoring data from backup server, continue to auto restore data into SQL Server Database.
13. Restore data from backup server only (we will separately run Vembu NetworkBackup through the ‘locally restored files’ to restore the SQL Server database later).
14. We have got these three options given below:
15. Lets choose the third option here and provide the Standby file location. Click Next.
16. Now you can review the configuration and click on Restore Now.
17. It will prompt you to confirm the restore operation to be executed. Click yes.
18. You can see the status for successful completion of the restore job.
19. You can also check the report by clicking on Reports > Restore Reports.
20. Click on Summary option and on VM hyperlink for report.
21. This is the restore report with all the details.
Topic Outline:
Backup MS SQL Database
Database Options
Scheduling
Differential & Transaction
Encryption
If you are using Vembu BDR suits then you have a application backup option also. we will take MS SQL backup via Vembu Network Backup.
2. After that install on the server where you are running MS SQL.
3. Open the console by typing URL : http://IP of server:4040 where the port is 4040.
4. Go to Backup tab as seen in the below image.
5. Now Click on the MS SQL Server option.
6. After this you can see below options:
SQL Server Instance name – you can select the database as per your requirement.
7. Authentication – use Windows or SQL Server Authentication.
Provide username and Password. Click next.
8. After choosing database, you can now select from the given below options to backup SQL instance.
9. Lets assume we choose the first option then it will automatically select the table given on right hand side.
10. Similarly when we choose the second option “All FULL Recovery Model databases”, the R.H.S table isn’t selected automatically.
11. When we go ahead and select the third option “All SIMPLE Recovery Model databases”, the R.H.S table is selected by default.
12. Select “All BULK_LOGGED Recovery Model databases” will not automatically select the R.H.S table.
13. In this option you can select the Frequency or when it will take backup like as given below:
a) Run Daily
b) Run Weekly
c) Run Once
d) Run Monthly
You can specify the time as well.
14. On the right hand side you can select Backup server or you have the option to add a backup server right here.
15. Here you can select Retention for this backup and click next.
16. Here you have the options like Differential backup or Transaction Log Backup or even you can keep this in Temporary location.
Note: you can also select Encryption as per company policy or customer requirement.
17. Enter your Job name and save the backup. Click next.
18. It will prompt you to reconfirm to go ahead and execute the backup configured.
19. You can check the status under dashboard option for the backup executed successfully.
Topic Outline:
Disaster Recovery
Restore Options
Restore Time
Restore Report
When there is a requirement for a client machine to reinstall a fresh Vembu NetworkBackup, in a case you loose all the configured backup jobs. In such a situation the Disaster recovery solutions is a life saving solution and that allows you to restore client configuration from backup servers.
Lets assume you have a client data which is relocated to another machine where resuming backup jobs will be required.
Note: If the backup job is encrypted or password protected, then the user will be required to provide the secured key or password by editing the backup job before resuming it.
Choose servers
Here you can see the progress and percentage for completion.(Note: In my case this is fast and done in seconds)
After completion of this restore job you can see below status.
Once restore completes successfully, you will be redirected to reports page with the report for successful restore completion. Here you can see all the reports for disaster recovery.
Topic Outlines:
User Management
New User
User Password Management
In the organisation, we have to manage or control the user management for better logs and tracking. In Vembu BDR suit you can achieve by create user or multiple users and assign them the permissions on user basis.
Now Login into Vembu BDR console > Management > under Server management > click on User management.
On this page, click on Create user button.
It will prompt you a window with following options given below:
Finally click on Create user option.
After creation of a user, you can see that user under list of Users along with their access privilege status and the reset password option. From here you can also delete a user.
After user creation or in case of a user forgot their password then you can use edit option from lists user and change the password here and click on update.
Topic Outline:
Failover VM Restore Version vCenter tasksLet suppose you are doing some work on your VM and suddenly it crash, now if you have Vembu BDR protection then you can use Vembu replica failover process which helps you to recover the replicated VMs at target host or other location in case of disaster. Using Vembu VMBackup, your critical VMs can be replicated from one VMware ESXi host to another. So, in case of system crash or software failure, you can instantly failover the VMs to the required recovery point at target host.Background:
When you will use Vembu BDR failover process in this process it will create a VM and to the replica VMs from the source VM for a while when the source VM is temporarily not available due to corruption or system crash. During that time this VM act as Main or Production VM.If the VM replication is configured with Network and IP-Remapping, the replica VM will run with the configured Network & IP configurations during the failover process. If Network & IP-ReMapping options were not configured during VM replication configuration, then IT admins need to manually assign Network and IP after failover process.Now if you want to recover to a specific point then you can also choose from available recovery points, and it is also possible to failover group of replica VMs which are actually dependant on one another that are available in the configuration.Now it will use VMware snapshot option and data created after failover will be maintained as delta file (vmware temp files) which will be committed/reverted later based on the user choice or requirement.Now Let see how to failover one vm and test the options.First login into Vembu BDR and go to VM Replication option > under that you can see number of VMs now choose one VM or multiple VMs as per your requirement and click on restore option mentioned in point 2.
Restore TypeRestore DataFinalize Type vCenter Activity We have already seen the background process or steps for failover a vm.When you will use Vembu BDR failover process in this process it will create a VM and to the replica VMs from the source VM for a while when the source VM is temporarily not available due to corruption or system crash. During that time this VM act as Main or Production VM.Failover is a temporary state that may be further finalized using any of the below processes:
2. Here you can see all these options but only one is highlighted which is Finalize Failover select and click on next.
3. Here select the VM and click next.
4. Failover is a temporary state that may be further finalized using any of the below processes:
Lets talk about these options:5. Permanent Failover: In case the source machine is not recoverable after a disaster or you want to continue business operations with the replica VM itself, then you can use permanent failover option. Permanent Failover helps IT admin to use the replica VM for production purpose permanently instead of source VM.All changes made during the failover process will be committed to the disk once the permanent failover is done. So, all the snapshots of the replica VMs will be consolidated. Further incremental will be blocked for the replica VM after the permanent failover process and the VM will be excluded from the VM replication job.
6. Undo Failover: Undo Failover is a process of reverting back the replica to its original state before failing over replica VM. The data added after failing over the replica VM will be terminated after the Undo Failover process.Undo Failover might be useful if the replica failover was initiated for testing purpose or if you get the original production server back after troubleshooting and if you don’t want the data that has been added after the failover process.
7. Failback: If you want to resume the source VM operation after disaster recovery and shift the production load back to the source VM, you can use failback process. (source: vembu.com)
8. Here it will start progress as per your selection.
9. In vCenter server under recent tasks you can see the progress for this VM.
10. It will show you the completed status under the restore progress option.
Topic Outline:
Restore File/Files
Recover particular one file/files and folder/folders from FLR backup in Vembu BDR.
File Level Restore (FLR) addresses these issues by providing a way to access individual files within a restore point. This access makes it possible to read copies of files or restore them from within restore points to any other available location.
To restore specific file/files or folder/folders from image backups without restoring the entire disk(s), we can use “File Level Recovery” option by attaching the backup disk(s) to the Disk Management and then copying the required files or folders from the attached volume.
Follow the below steps to perform File Level Recovery from Vembu Network Backup Server
Now Go to Restore tab and Click on Restore button which is highlighted in blue.
In the below screen we have three files for demo purpose, first i will delete one file and then we will restore it.
Case scenario: If a user deletes any file or folder accidentally in production environment, in that case FLR is good option.
You need to right click on the file and click delete.
Even you also have versioning control for restore points.
Now Select version to restore file and you can have multiple restore points here.
In this section select Files/Folders to restore > select the file.
In Restore Settings Section; if file is password protected then need to provide password.
There are some more settings like:
Restore to Same Machine
Restore Deleted files only, include deleted files or skip deleted files.
Under Restore to option > you can restore this file on Original location or different location.
For different location you have to click on folder option and provide the path.
Under Advanced Options you have three options:
a) Rename the restored file with a .SG extension and keep the existing file as it is. [Recommended]
b) Rename the existing file with a .SG extension and restore the backed up file as it is.
c) Overwrite the existing file with the restored file. If the existing file is different from the backed up file being restored, the contents of the existing file will be lost. [Not Recommended]
Note: If the original file is already present in the restore location, then the restored file will be saved with an extension SG (eg. a.doc will be saved as a.doc.sg).
Final step click on restore and check the location of file as per your selection by reviewing the configuration. Click on restore now button.
Click Yes.
Finally your file has been restored within few clicks.
On Vembu Network Backup server you can check the status of last backup restored.
Feeds