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

Published: 05 June 2022
on channel: Chirags Tutorial

[email protected] Chirag's SQL Server DBA Tutorial https://www.chirags.in
*****************************************************************************************
How to Restore a Database From Full Backup in SQL Server *
*****************************************************************************************

Data restore is the process of copying backup data from secondary storage and restoring it to its original location or a new location. A restore is performed to return data that has been lost, stolen or damaged to its original condition or to move data to a new location.

We will be using two ways to Restore a Database From Full Backup in SQL Server
1. Using SQL Server management studio graphic user interface GUI Version
2. Using T-SQL script

/** Transaction **/
begin trans
select * from actor;

commit trans;

sp_who2;

/**T-Script**/
USE [master]
ALTER DATABASE [DVDRentalNew] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
BACKUP LOG [DVDRentalNew] TO
DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\DVDRentalNew_log_export.bak'
WITH NOFORMAT, NOINIT,
NAME = N'DVDRentalNew-Log Database Backup',
NOSKIP, NOREWIND, NOUNLOAD,
NORECOVERY , STATS = 5
RESTORE DATABASE [DVDRentalNew] FROM
DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER1\MSSQL\Backup\DVDRentalNew.bak' WITH FILE = 1, NOUNLOAD, STATS = 5
ALTER DATABASE [DVDRentalNew] SET MULTI_USER
GO

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
/ @chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :
https://www.chirags.in/tutorials/micr...

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#DBATutorial
#DBATutorialLearning
#DBAEducation
#DBATutorialFree
#DatabaseTutorial
#SQLServerDatabaseTutorial
#SQLServerDBATutorial
#MicrosoftSQLServerDatabaseTutorial
#ChiragsDBATutorial
#ChiragsDatabaseTutorial
#ChiragsSQLServerDatabaseTutorial
#ChiragsSQLServerDBATutorial
#Chirags.inSQLServerDBATutorial
#ChiragsMicrosoftSQLServerDatabaseTutorial
#CreateDatabaseinSQLServer
#CreateDatabasewithT-SQL
#chiragstutorial
#databasetutorial
#sqlserver
#sqlservertutorial
#sqlservermanagementstudio
#sql_server
#sqlservertutorial
#chiragstutorial
#databasetutorial
#sqlqueries
#sqldba
#database
#databasemanagement

Watch video SQL Server DBA Tutorial 5 - How to Restore a Database From Full Backup in SQL Server online without registration, duration hours minute second in high quality. This video was added by user Chirags Tutorial 05 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 65 once and liked it 2 people.

5,521