Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: SQL Server Objects > Databases > Working with Databases > Restore Databases

Restore Databases

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

Troubleshooting: For a valid script generation, make sure that the file paths to the destination database are correct.

To restore a database

Select the Databases node in the Object Explorer.
Right-click a database and select Restore Database.
Default backup database is selected automatically.
Tip: To load backup from File or external Device without specifying database (for example, if you want to create new database from a backup), right-click the Databases node and select Restore Database.

Complete the Destination page. Review the following for additional information:

Destination page	Description
Set database single user mode	Select True to close other connections to selected Database.
Replace existing database	Select True to replace the current database with the restored database, overwriting any data entered since the last restore.
Undo file	Specify a location for a rollback file if you want to undo the restore operation. Note: This option is only available if you selected Restore with standby as the recovery state.

Select the location of the database files and alter it if necessary. Click to change a directory. Review the following for additional information:

Destination Database Path—Defines database files location in current SQL Server instance where the backup will be restored.
Backup Path—Defines location of original database files that were used for backup using RESTORE HEADERONLY.
Note: Be careful especially when restoring database from backup that was originally created on another SQL Server instance. Backup Path is stored in backup file and is defined using RESTORE HEADERONLY. The path may be invalid for the target database where you intend to restore a backup.
SQL Server Defaults—Defines default location for the database files in the current SQL Server instance.

Select Generate File Names to generate new database file names based on the target database name.

Complete the Options page. Review the following for additional information:

Options page

Description

Logging Level

Select one of the following options:

None—LiteSpeed does not log backup activity.
Errors only—LiteSpeed logs errors during the backup process.
Verbose—LiteSpeed logs all backup activity. Verbose logging can cause large log files.
Verbose on failure—LiteSpeed creates verbose logs and only saves them if the back up fails. If it succeeds, LiteSpeed does not save the log.

Notes:

Selecting Verbose on failure can significantly reduce the troubleshooting process if the activity fails.
These options are only available if LiteSpeed™ for SQL Server^® is installed. See LiteSpeed for SQL Server web page for more information.