Restore entire database - TSQL Tutorial

Restore a full database backup from the logical backup device.

RESTORE DATABASE Syntax:

RESTORE DATABASE { database_name }
[ FROM [ ,...n ] ]
[ WITH
{
[ RECOVERY | NORECOVERY | STANDBY = {standby_file_name} ]
| , [ ,...n ]
| ,
| ,
| ,
| ,
| ,
} [ ,...n ]
]
[;]

RESTORE DATABASE Example:

USE master;
GO
RESTORE DATABASE test_2
FROM test_2;
GO

Messages:
Processed 328 pages for database 'test_2', file 'test_2' on file 1.
Processed 2 pages for database 'test_2', file 'test_2_log' on file 1.
RESTORE DATABASE successfully processed 330 pages in 0.276 seconds (9.333 MB/sec).