hi guys this is mina, welcome back to my channel
today we are going to discuss database backups in SQL server
management studio at the end of this video you would know
what is SQL Server database backup, the types of database backups
and also learn how to backup databases in SQL server management studio
database backups create a copy of databases
that can be restored and this helps prevent
complete data loss in the event of hardware or software
failure, data corruption, accidental deletion
or even virus or malware attacks
sql server supports three different types of database backups
the first i'm going to talk about today is the full backup
the full backup as its name implies will backup
all the data, tableS and everything within the database
next we have differential backup this is used to backup data that has
changed since the last full backup so for instance if i took a full backup
yesterday then today i could take a differential
backup and the only thing that is going to be
backed up will be any data that has changed between yesterday and
today and since we are backing up less data
with differential backup, this backup method is quicker compared to the full
backup the third option is the log backup
which will backup all the sql transaction logs
so let's go ahead and launch our sql server management studio
okay so in our sql server management studio
under object explorer click on the plus sign to
open the databases these are all databases that i have
in my management studio and i'm going to back up the student records
database that we created in my previous video, if you want to know how we created
this database and the tables in this database
click on the link above or in the description section
to watch my previous videos okay so once you open databases under object
explorer right click on the database you want to
backup and go to task, under tasks you'll find
the option that says backup. i'll click on backup
and this opens a dialog box where i can set different options about the backup
first it is asking me which database i want to backup
i've already selected the database i want to backup so i would leave it as it
is however if you want to select a
different database you can click on this drop down
arrow and make your selection next it is asking me what type of backup
i want to do like i mentioned previously we have full
differential and log backup i'm going to demonstrate the full backup
in this video you can also select any of these
options if you want to do either differential or
transaction log backup so i'm going to go with full backup
and we want to back up our database so i would leave this selection as it is
the destination of the backup could either be
on a disk or URL, i prefer to backup onto a disk for the file location
my default c drive location has been selected
so i would go with this option i do not wish to change it
however if you want to change it you can click on this
add button and click on this to make your changes since i want to go
with my default location i'll just cancel this
and under the media option i'm going to accept most of the defaults
the one thing i would like to change however is to verify the backup when
finished it's always a good thing to verify your
backups so i'll check this box next to
verify backup and then i'll go to the backup
options page as well, this gives me the name of the backup
which i want to maintain and also under compression, i wish to reduce the
size of my backup choose the option that says compress
backup and that's all i want to do on this page so i'll go
ahead and click ok backup has been completed successfully
so i'll click ok. let's go on to the file location
and see our backup file there we have it so this is my file
location and this is the backup that we've just
created. so guys this is how to backup databases
in sql server management studio. In my next video i'm going to show you
how to automatically backup databases at specific times
so stay tuned and have a good day bye bye