Whenever I am suggesting something which changes how database works or the existing status of the database, my suggestion along with it is to take the database backup before making such changes. If the changes are in configurations, that can be easily revert but if the changes are such that it will impact the data, I always suggest to take backup. The nature of this blog is such that we have readership from readers with different expertise, some are experts and some are novice.
One of the questions I keep on receiving comments are whenever I give suggestion to take a full database backup is – how to take database backup. It is not possible to explain in each and every blog regarding how to take backup of the database as it will be of no interest to the users who are very much familiar with this concept. To help the beginners who have yet to learn regarding how to take database backup, here is the SQL in Sixty Series episode which explains how to take database backup.
There are three types of the backup – 1) Full Backup 2) Differential Backup and 3) Log Backup. We can take the differential backup as well log backup from the same screen where we take full backup from. I have explained the same also in later parts of the video.
If you are using SQL Server Management Studio – here is the path which will bring you to the screen where you can take various kinds of backup.
Right Click on Database >> Tasks >> Back up…
Let us see how to take backup in this SQL in Sixty Seconds:
Please note that if your database is large, it will take long time to take backup. We will focus on the various steps to initiate the backup in this video.
Related Tips in SQL in Sixty Seconds:
- Backup Timeline and Understanding of Database Restore Process in Full Recovery Model
- Select the Most Optimal Backup Methods for Server
- Mirrored Backup and Restore and Split File Backup
- Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions
- A Quick Script for Point in Time Recovery – Back Up and Restore
- Copy Database from Instance to Another Instance – Copy Paste in SQL Server
- Effect of Compressed Backup Setting at Server Level on Database Backup
What would you like to see in the next SQL in Sixty Seconds video?
Reference: Pinal Dave (http://blog.sqlauthority.com)