SQl Restore

RESTORE DATABASE PROD FROM disk = 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\MyBackup\UnZipped\dbase_FULL_20151215_230000.bak'

WITH  REPLACE, FILE = 1, NORECOVERY, STATS=5, MOVE 'dbase_dat' TO 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\dbase.mdf', MOVE 'dbase_Log' TO

'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\dbase_Log.ldf'

RESTORE LOG dbaseRecovering FROM DISK = 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\MyBackup\UnZipped\dbase_backup_2015_06_05_040006_5970059.trn'

WITH NORECOVERY,  FILE = 1;

RESTORE LOG dbaseRecovering FROM DISK = 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\MyBackup\UnZipped\dbase_backup_2015_06_05_043000_6483931.trn'

WITH NORECOVERY,  FILE = 1;

RESTORE LOG dbaseRecovering FROM DISK = 'D:\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLMyBackup\UnZipped\dbase_backup_2015_06_05_050001_0024105.trn'

WITH NORECOVERY,  FILE = 1;

--Put database back into  operation

RESTORE DATABASE {0}  WITH RECOVERY