Let’s assume that you have to administer over 100 databases stored on multiple computers. How can you make sure that every backup job is done as scheduled?
It’s really difficult and very inconvenient to check computers one by one. In this case, the best way is to use an online service, such as SqlBak. With SqlBak, you will be able to manage multiple SQL backups from a single station.
All you need is to download and install a tiny SqlBack App on every computer that you are going to administer. Once you complete installation you will be able to manage multiple SQL backups from the Internet.
Once installed, go to your dashboard and get a secret key by clicking on “Show secret key” button:
Copy it and insert into SqlBak App:
Now you need to connect SqlBak App to your MS SQL Server. This is the only thing that you have to do from the remote computer:
Once you’ve installed SqlBak App and connected it to SQL Server from all remote computers that you are going to administer, go to Computers page and look for information related to computers connected to your account:
Here is what you’ll see there:
- Computer Name – name of connected computer, you can name them as you wish
- Status – indicates whether a computer is available and connected to the SQL Server
- Monitoring – you can turn it on or off
- Jobs – a list of your backup and maintenance jobs related to this computer
Now you can add any scheduled backup or maintenance jobs by clicking “Add new job” link.