How to Restore a Database From Full Backup in SQL Server - SQL Server DBA Tutorial

In this video you will learn how to restore SQL Server Database from Full backup, it goes through various options of restoring database using Full backup such as restore as, renaming sql server database while restoring, recovery models of SQL Server database, Tail log backup options using SQL Server management studio as well as restoring SQL Server database using T-SQL Script.

Scripts used in video to
 USE [master]
 ALTER DATABASE [SalesOrders] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
BACKUP 
LOG [SalesOrders] TO
DISK = 
N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\Backup\SalesOrders_LogBackup_2015-03-03_17-05-52.bak' 
 WITH NOFORMAT, NOINIT, 
 NAME = N'SalesOrders_LogBackup_2015-03-03_17-05-52', 
NOSKIP, NOREWIND, NOUNLOAD
 NORECOVERY ,  STATS = 5
RESTORE DATABASE [SalesOrders] FROM
DISK = 
N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\Backup\FullBack.bak' WITH  FILE = 1,  NOUNLOAD,  STATS = 5
 ALTER DATABASE [SalesOrders] SET MULTI_USER
GO





Restore a Database From Full Backup in SQL Server