Free SQL Server Backup Fast Restore Software
Sql database One-Click SQL Restore
This simple free tool
restores full MS SQL server database backups created using BACKUP DATABASE command or Why use One-Click SQL Restore instead of RESTORE command?
Because One-Click SQL Restore is much faster. It unzips the bak file if necessary, it connects to the SQL server on the start, it selects the right database, it is smart enough to restart the server to drop open connections if necessary - all you have to do is to press "Restore" button.
One-Click SQL Restore is most useful if you restore often. If you are a developer that needs to restore databases a number of times - it will save you tons of time. However it won't replace the RESTORE command in a complicated restore scenario.
Typical Scenario
Let's say you want to restore a backup created using
SQLBackupAndFTP or BACKUP DATABASE command
- Double-click a *.bak file, or drag-and-drop *.bak or *.zip file onto One-Click SQL Restore
- Select a Target database or type a new name
- Press "Restore" button.
FAQ
Q: Can I restore not only full, but also differential backups?
A: No. Only Full. Use
RESTORE for diff backup restore.
Q: I need other options: transaction log restore, file restore, snapshot, restart, etc?
A: Use
RESTORE command instead. One-Click SQL Restore should be used in simple scenarios only.
Q: Do you overwrite the files when restoring to another database?
A: When restoring a backup from database X to database Y, we use "MOVE" option so Y files get overwritten.
Q: Restore errors
A: Most common errors are "The media family on device .. is incorrectly formed", "RESTORE HEADERONLY is terminating abnormally", "The backup of the system database on device .. cannot be restored because it was created by a different version of the server" - they all occur when you try to restore to an older SQL server. You can NOT restore backups from a newer SQL version to an older - the formats of (Microsoft) backup files are different. See our
post on this.
Q: Does it have Command Line Interface?
A: Yes. Usage:
SqlRestore [options]
Options:
-run - runs the program in automatic (console) mode
-db - a target database where the backup file will be restored to
-srv - SQL Server instance name
-usr - SQL Server user name (if not specified, then Windows Authentication will be used)
-pwd - SQL Server user password (if not specified, then emptypassword will be used)
-help or -? shows this help
Q: Do you guarantee the safety of the data?
A: No (nobody would). Under no circumstances we accept any responsibility for the use and performance of this program. It is provided to you "AS IS" - use at you own risk (See
EULA). In general, database backup and restore operations should only be handled by a person who knows what he is doing. It is very easy to overwrite an existing database and loose the data. If in any doubt - don't do it yourself, find a professional that could help.
Q: What license is it under?
A: It is a
freeware - free of charge even for commercial use, you can install it on any number of systems, you will not have any proprietary rights, you can distribute it as long as you don't make money, you can not make it part of your program. See
full freeware license
Click to Download free fastest Sql server database restore
