Restore Database (Options Page)
Use the Options page of the Restore Database dialog box to modify the behavior and outcome of the restore operation.
To use SQL Server Management Studio to restore a database backup
When you specify a restore task by using SQL Server Management Studio, you can generate a corresponding Transact-SQL script containing the RESTORE statements for this restore operation. To generate the script, click Script and then select a destination for the script. For information about the RESTORE syntax, see RESTORE (Transact-SQL).
To modify aspects of the behavior of the restore operation, use the options of the Restore options panel.
To determine the state of the database after the store operation, you must select one of the options of the Recovery state panel.
Allows you to designate that a tail-log backup be performed along with the database restore.
Allows you to close existing database connections.