Step 7. To Generate TSQL Script for the database restore click Scripts and choose Script Action to your choice from the different options which are available as shown in the snippet below.
Step 8. Once the database is successfully restored you will get a popup message similar to the one shown in below snippet.
How to Restore a Full Database Backup in SQL Server Using TSQL Scripts
The below script can be used to restore AdventureWorks database. Change the Database File Path as per your existing setup and specify the correct Backup File location.
RESTORE DATABASE [AdventureWorks] FROM DISK = N'C:\DBBackups\AdventureWorks.BAK' WITH FILE = 1, MOVE N'AdventureWorks_Data' TO N'D:\MSSQL\MSSQL10_50.SQL2008R2\MSSQL\DATA\AdventureWorks.mdf', MOVE N'AdventureWorks_Log' TO N'D:\MSSQL\MSSQL10_50.SQL2008R2\MSSQL\DATA\AdventureWorks.ldf', NOUNLOAD, REPLACE, STATS = 10 GO
In this article you have seen the steps to restore a database from its full backup.