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

हम दो तरीकों का उपयोग करेंगे मैन्युअल रूप से एक डेटाबेस का पूर्ण बैकअप लें(We will be using two ways Manually Take Full Backup of a Database) :-
1. Using SQL Server management studio graphic user interface GUI Version
2. Using T-SQL script

C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLBackup

/** Backup Script **/

BACKUP DATABASE [DVDRental]
TO DISK = N’C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLBackupDVDRental.bak’
WITH RETAINDAYS = 10, NOFORMAT, NOINIT,
NAME = N’DVDRental-Full Database Backup’,
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

/** Backupset Varification**/
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N’DVDRental’
and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N’DVDRental’ )
if @backupSetId is null begin raiserror(N’Verify failed. Backup information for database ”DVDRentals” not found.’, 16, 1) end
RESTORE VERIFYONLY FROM DISK = N’C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLBackupDVDRental.bak’
WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
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