With the help of SqlBak you can make not only scheduled database backups but also restore SQL Server backup when you need. In this blog post, we are going to explore the possible ways of restoring your database with the help of SqlBak.
Lets assume that your database backup plan is full backups once a day at 00:00, differential backups every 6 hours, and transaction log backups every 30 minutes. Everything works fine, all backups are being made according to your schedule but something has happened and your server fell down and all the data is gone. What will you do in this case? Will you panic or just click the restore button on your SqlBak Dashboard? Follow these simple steps and learn how to restore SQL Server backup.
How to Restore SQL Server Backup
To restore SQL Server backup with the help of SqlBak go to your SqlBak Dashboard page. If you need to restore your last backup and it does not matter for you will it be a full, a differential or a transaction log backup, then simply press the “Restore” button. If you prefer to choose the backup that you want to restore, then click on your desired backup job. In the right part of the window, you can find the list of all your database backups. In order to restore SQL Server backup select the one and then click “Restore” button.
In the opened window you can find the backup which you are going to restore. You can restore SQL Server backup on your computer or on another computer. To start restoring the database to your computer simply click “Restore”. If you need to restore SQL Server backup on another computer, click “on another computer” link. In the new window check the computer’s name and click “Restore” button. Once the restore SQL Server backup operation has been finished you will receive the following message:
As you can see, you can restore SQL Server backup in a few simple steps. Go to your “Dashboard” page, click “Restore” to restore your last database backup, or open your backup job and select the one that you need to restore and simply press “Restore”.