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



2 comments:


  1. I am very impressed with your post because this post is very beneficial for me and provide a new knowledge…
    incracks.com
    restoro-crack
    nitro-pro-crack
    advanced-systemcare-pro-crack

    ReplyDelete
  2. Such a Nice post. Thanks for Awesome tips Keep it up
    restoro-crack

    ReplyDelete