[email protected] Chirag’s SQL Server DBA Tutorial https://www.chirags.in
*****************************************************************************************
* SQL Server में पूर्ण बैकअप से डेटाबेस को कैसे पुनर्स्थापित (Restore)करें *
*****************************************************************************************

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

/**T-SQL Script**/
USE [master]
ALTER DATABASE [CHIRAGS] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
BACKUP LOG [CHIRAGS] TO
DISK = N’C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLBackupCHIRAGS_log_export.bak’
WITH NOFORMAT, NOINIT,
NAME = N’CHIRAGS-Log Database Backup’,
NOSKIP, NOREWIND, NOUNLOAD,
NORECOVERY , STATS = 5

RESTORE DATABASE [CHIRAGS] FROM
DISK = N’C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLBackupCHIRAGS.bak’ WITH REPLACE, FILE = 1, NOUNLOAD, STATS = 5
ALTER DATABASE [CHIRAGS] SET MULTI_USER
GO

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
https://www.youtube.com/channel/UCLdaO4-i_gxQMi87JwjKOwA
💛Don’t forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

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

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
#sql
#sqlserver
#sqlservertutorial