SqlBak.com is the only service that allows you to backup and restore SQL Server databases through your browser. You would need to install a small service program on your SQL Servers computer – everything else is done through your control panel on SqlBak.com
The most important task for a DBA is to provide regular database backups. In this case you need some kind of scheduler that will perform backups automatically. You can tune the job scheduler if you own full version of Sql Server, but if you need to perform SQL Server Express backup then you probably need some third-party backup tool.
SqlBak allows you not only to run scheduled SQL Server Express backups and send them to Dropbox, but also to manage them via the web. Let’s see how to do it.
Create an SqlBak Account
Install SqlBak App
To connect this installation to your SqlBak account, you need to enter a secret key from your SqlBak account into this app. To get your key, go to SqlBak Dashboard, click the “Secret Key” button, then copy your key and paste it into the “Secret Key” field in the SqlBak app.
Create a new job
Click on Add new job link to start creating a new backup.
Select one of the connected SQL Server computers (where you have previously installed the SqlBak App), select or type the name of the SQL Server you are connecting too (“.” or “.sqlexpress” are the most common), and then specify the credentials (a Windows or SQL Server account) with sufficient rights to connect to the SQL Server and run the backup job. The credentials will be stored encrypted. Please note that there will be no connection from the outside to your SQL Server. The SqlBak App running on the same computer will use this account.
The Dropbox authorization page will open in a new browser window. Log in to your Dropbox account if necessary and click “Allow” button to allow SqlBak to connect to your Dropbox. Note that the app will only have access to files in the new /Apps/SqlBak/ folder in the Dropbox.
The window with the Dropbox Request Authorization will close in a few seconds and you will see the updated “Dropbox Settings” window. Note that the backups can only be stored in /Apps/SqlBak/ folder in the Dropbox. Click on “Save & Close” to return to the “Job Settings” page.
Here you can also schedule the job to make full, differential and transaction log backups.