Home > Welcome to the Bacula Enterprise Trial > Using Bacula Enterprise Trial Edition > Restore a Microsoft SQL server database in a Windows client using the VSS Plugin via Bweb Management Suite

Restore a Microsoft SQL server database in a Windows client using the VSS Plugin via Bweb Management Suite

 

In order to restore the database AdventureWorksDW please follow this short procedure:

  1. From the main page click on Jobs, "Web Restore" and choose the client:
  2. Select the MSSQL backup job executed on scenario 8:
  3. Drag the database to the "Restore Selection Area" at the bottom right:
  4. Set the name of the new database to restoreAdvWorks and click on "Run Restore"
  5. The restore log must indicate if the database was correctly restored and if further action is necessary:

    2019-12-16 12:07:55 bacula-enterprise-trial-dir JobId 2: Start Restore Job Restore.2019-12-16_12.07.53_15
    2019-12-16 12:07:55 bacula-enterprise-trial-dir JobId 2: Restoring files from JobId(s) 1
    2019-12-16 12:07:56 bacula-enterprise-trial-dir JobId 2: Using Device "DedupAutochanger_Dev1" to read.
    2019-12-16 12:07:56 bacula-enterprise-trial-sd JobId 2: Ready to read from volume "DedupVol-0001" on File device "DedupAutochanger_Dev1" (/mnt/bacula/dedup/volumes).
    2019-12-16 12:07:56 bacula-enterprise-trial-sd JobId 2: Forward spacing Volume "DedupVol-0001" to addr=282
    2019-12-16 12:08:03 bacula-enterprise-trial-sd JobId 2: Elapsed time=00:00:07, Transfer rate=1.245 M Bytes/second
    2019-12-16 12:08:06 win-mssql-fd JobId 2: VSS plugin start restore Job.
    2019-12-16 12:08:29 bacula-enterprise-trial-dir JobId 2: Bacula Enterprise bacula-enterprise-trial-dir 12.0.2 (26Aug19):
    Build OS: x86_64-redhat-linux-gnu-bacula-enterprise redhat Enterprise release
    JobId: 2
    Job: Restore.2019-12-16_12.07.53_15
    Restore Client: win-mssql-fd
    Where: restoreAdvWorks
    Replace: Never
    Start time: 16-Dec-2019 12:07:55
    End time: 16-Dec-2019 12:08:29
    Elapsed time: 34 secs
    Files Expected: 4
    Files Restored: 4
    Bytes Restored: 8,716,710 (8.716 MB)
    Rate: 256.4 KB/s
    FD Errors: 0
    FD termination status: OK
    SD termination status: OK
    Termination: Restore OK2019-12-16 12:08:32 win-fd JobId 2: Database was restored: Database: restoreAdvWorks, creation date(time): 2019/08/19(21:25:07), first LSN: 61:271:37, last LSN: 61:287:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{B5A8E7E4-C2E2-48E7-9F6D-037C05AA3D0A}'}). Informational message. No user action required.

………………………………

We hope that you enjoyed using Bacula Trial Edition. You still have the opportunity to further test some of your Bacula Trial installations’ other features. Please refer to our main manual, in particular the chapters "A Brief Tutorial" and "Getting Started with Bacula".

If you have any comments or suggestions please fill out the feedback form and let us know. We'll get back to you in a timely fashion, and would like to thank you in advance.

For more information about plugins, support options, features, training and pricing, please contact the sales team via our contact form.

If you are not able to complete these scenarios, or have a technical issue regarding any products, please contact the support team via the welcome screen of the .ova, as below:

Bacula Enterprise is used by a large number of high-profile customers, where each one exploits the special qualities of Bacula in a variety of different ways. Bacula Systems looks forward to bringing the same benefits to your organization; please contact us to find out how we can best help you to move forwards, modernize your backup and recovery strategy, and significantly reduce costs.

Bacula Enterprise Features Overview

 

With our best regards,
The Bacula Systems Support Team

Additional notes: The Bacula Enterprise Trial VM will stop working after 30 days. If you would like to continue testing after this time, you can simply click the “Reset Bacula Enterprise Trial environment” icon on the Landing Page, or re-import the Trial ova.