Requirements

  • The supported SQL Servers: 2008, 2008 R2 and 2012.
  • The OBRM application must be installed on the same machine where the MS SQL Server installed.
  • The MS SQL Server 2008 or 2012 Shared Management Objects (sharedmanagementobjects.msi) and Microsoft System CLR Types (SQLSysClrTypes.msi) must be installed.

Backup SQL Databases with OBRM

When the OBRM v6.5.0+ installed and the SQL DB created on the machine, the Backup procedure can be started.

  • Launch the OBRM application;
  • Click on the “wrench” icon opposite to “MS SQL Server Backup”;

           User-added image

Database Selection, Retention Policy and Authentication Policies

  • The OBRM will automatically detect and list supported SQL databases, just select the databases to backup

            User-added image 

If the database has already been backed up, the Last Full and Differential Backup Dates will be listed

  • Select the necessary backup and retention policy options

           User-added image

  • The user can set a retention policies for the full and differential backups based on age in days.

Only a single Full and, optionally, a single Differential backup file are required to recover your SQL Database.

If you decided to keep the latest copy of backup locally (it will be saved and kept in folder you selected as “Temp folder path”) please check the correspondent field.

If you don’t want to use the current credentials, please uncheck “Use Windows Authentication” and fill the user credentials you prefer

           User-added image

Don’t forget to check “Test Connection” to be sure that selected credentials can be used.

                User-added image

The “Temp folder path” is used to store the SQL Database(s) selected for backup while processing and preparing for online backup (create a backup file, compress, encrypt and then transfer it). While filling “Temp folder path” field you may select different credentials, appropriated to the selected path. The “Temp folder path” and its credentials must be setup for each database separately.

          User-added image

  • When finished with backup options, click on “Next” to schedule your backup time

Scheduling Options

              User-added image

If you choose “Backup even when Windows user is not logged on” you have to provide the credentials for the account on behalf of which this backup will run.

              User-added image

Do not forget to fill the email address to which backup reports will be sent.

If you want the Backup job will run right after you complete with the wizard, check the field “Run backup at the end of wizard”.

  • When all necessary data filled just click on “Finish” to complete the wizard.

If you selected Run backup at the end of wizard, your backup will start immediately and you will get the results as follows

 User-added image

Restoring SQL Databases with OBRM

Use the OBRM to restore protected SQL Databases to your local machine by selecting the Restore Tab, refreshing your backup set

Restoring from the cloud:

  • Select Restore procedure

             User-added image

Selecting your Database(s)

  • Find your machine, database and the date of backup you want to restore
    • Full Backup

             User-added image  

  • Differential Backup

  User-added image
 

For best recovery speed, it may be best to first restore the full to your machine without selecting the differentials. Then, go back and select the differential backup file to which you would like to restore.

  • Right button of the mouse click on selected .bak file and choose Recover
  • Select the location for restored file and click on “OK”

            User-added image

  • Wait for the recovery process completion

            User-added image


Restoring to SQL

Once you have the backup files you need on your local machine, use SQL Management Studio to recover the full and after this - the differential backup if exist.

Instructions can be found at http://www.howtogeek.com/50354/restoring-a-sql-database-backup-using-sql-server-management-studio/