Restore Database (General Page)
Use the General page to specify information about the target and source databases for a database-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 the corresponding Transact-SQLRESTORE script by clicking the Script button and then selecting a destination for the script.
You can restore a user database from a database backup created by using SQL Server 2000, SQL Server 2005, or SQL Server 2008. However, SQL Server 2008 uses a different default path than earlier versions. Therefore, to restore a database from backups created in the default location of either SQL Server 2000 or SQL Server 2005, you must use the MOVE option. For more information, see Copying Databases with Backup and Restore.