Need to restore an SQL Server database backup?

SQLBackupAndFTP will do this for you!

  • Properly handles full, differential and transaction log backups
  • Restores from SQL scripts and BACPAC containers
  • Supports Zip and 7zip archives
  • Automatically downloads backups from FTP, Amazon S3, Dropbox, Google Drive, OneDrive, Box, Backblaze B2 and Yandex Disk as well as from a local folder
  • Restores several databases at once
  • Provides you with a detailed log and backup history
  • Does all this for FREE!

Download SQLBackupAndFTP

SQL Restore

  1. Create a restore job
  2. Select the backup location (local or cloud)
  3. Select databases to restore
  4. Select the SQL Server you want to restore the backup to
  5. Run the restore
  6. Keep restore history

To get more information read How to Restore SQL Server Backups.

FAQ


What if I have full, differential and transaction log backups?
No problem, you can choose any of them as a recovery point and SQLBackupAndFTP will handle all of them properly. First, the full backup will be recovered, then the last differential backup and then all transaction log backups up to the selected recovery point.
Do you overwrite the files when restoring to another database?
When restoring a backup from database X to database Y, we use the "MOVE" option so Y files get overwritten.
Restore errors
The most common errors are "The media family on device .. is incorrectly formed," "RESTORE HEADERONLY is terminating abnormally" and "The backup of the system database on device .. cannot be restored because it was created by a different version of the server." These all occur when you try to restore to an older SQL server. You cannot restore backups from a newer SQL version to an older one, because the formats of Microsoft backup files are different.
Do you guarantee the safety of the data?
No (nobody would). Under no circumstances do we accept any responsibility for the use and performance of this program. It is provided to you "AS IS" — use at your own risk (see Terms of Service). In general, database backup and restore operations should only be handled by a person who knows what they are doing. It is very easy to overwrite an existing database and lose the data. If in any doubt, don't do it yourself — find a professional that can help.
What license is it under?
See our FAQ on licensing for answers.
Where can I get support?
Free users receive support through the forum. If you have a valid full-service subscription you can get email support from our team.