SQL SERVER – Configure, Monitor and Restore Backups from Mobile & Web browser

SQL
No Comments

So tell me if this is a fantasy or a reality about restore backups: You are on a beach, sipping on your cocktail and looking at the sea when you get a frantic call from your boss, “One of the junior DBAs has just deleted all of the data from a critical database”. You say “Hold on”, switch to a browser on your smartphone, go to your dashboard on SqlBak.com and click a Restore button on your latest transaction log backup. In a few seconds, you get back to your boss and say: “I have fixed it”. Your boss is stunned, thinking you are a magician and makes a note to give you a raise and a bonus while you continue enjoying the beach…

Well, the beach and the pay raise are a fantasy, but restoring your database in a couple of clicks through just a browser on your smartphone is a service you can use today – it is called SqlBak.

This is how it looks like – you select a backup job, click Restore and the latest backup will be restored to your SQL Server:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak001

Let’s see how to make it works

First – boring stuff: go through 10 seconds signup with your Facebook, Twitter or Google account. Then (and here’s the secret to a magic of SqlBak working through a browser) – download and install a small service program to run on your SQL Server computer – SqlBak Client.

To connect this program to your SqlBak account, enter your “Secret Key” from SqlBak Dashboard

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak002

into the SqlBak Client (it will prompt you for it):

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak003  

The service program (SqlBak Client) has practically no interface and after connecting it to your SqlBak account you can forget about it (it will also auto-update). All of the configuration, monitoring and restore interface will be online through SqlBak.com, not through the program directly.

Now the fun part begins.

Solarwinds

Go to the SqlBak Dashboard and click “Add New Job” button.  Select the computer where you have previously installed and connected the SqlBak Client and authenticate with the SQL Server – exactly like you’d do in SSMS.

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak004

Press Continue and you get to the Job Settings page. Select the databases you want to backup:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak005

Then Press “Add Backup Destinations” to select where you want to store the backups – you have an option of sending it to you Local/Network folder, FTP, Amazon S3, Dropbox, Google Drive, MS OneDrive or Azure Storage:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak006

I’ve selected to send backups to Amazon S3 and a Network Folder:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak007

Lets schedule the full backup to run every 6h and differential backup every 1 hours:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak008

By default it takes standard backup files and compresses them to zip – lets keep it like that:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak009

You would probably want to receive a confirmation email at least on any failure – so fill out that field:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak010

Now save the job and press Run Now to see if everything runs correctly:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak011

You would see a log like this:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak012

Now we can forget about it – it will email us if anything is wrong. If we get back to it in a few days – heres what we would see a backup history like this:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak013

For each successful backup you have the Download and Restore buttons. Let’s click on the Restore buttons to restore one of the Differential backup. Select the destination to restore from (Amazon S3 or a network folder in our case):

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak014

You will see a restore progress bar:

SQL SERVER - Configure, Monitor and Restore Backups from Mobile & Web browser SqlBak016

In a few minutes your database is restored.

Absolutely brilliant! I know of no other product that would allow me to do the same from just a browser. It took quite a few pictures to describe the process, but in reality it takes just a few minutes and pretty self-explanatory.

In addition to backups this service would monitor that your SQL Server is alive and would email you if it goes offline – very useful.

Companies that want to provide Sql Server private label backups themselves can configure the service so it is branded to their company.

Some companies with strict security requirements may be hesitant of storing SQL Server login credentials with SqlBak. I’ve contacted the developers and they have told me that they are working on a version that would give user a choice of entering login credentials on the client – this way they would never leave the SQL Server.

Conclusion: I have seen many SQL backup programs before, but I am seriously impressed with the ease of using SqlBak – the only SQL backup software where you can configure, monitor and restore backups right from the browser.

If you enter the promo code Pinal2015 on the Sign Up page and you will receive $20 credit to your account.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , ,
Previous Post
SQL SERVER – COLUMNSTORE and COLUMNSTORE_ARCHIVE data compression
Next Post
SQL SERVER – Storing Data in Hindi, Chinese, Gujarati and Tamil (or any other) Language in the Same Table

Related Posts

Leave a Reply

Menu