March 9, 2017

How to Create a Differential Database Backup and Restore in SQL Server 2012 online training clip

This is an Example of differential backup in SQL server 2012 . Following is the
Step-by-Step Approach to Differential Backup for database.

1.let us create one database
2.Now create  one single table
3.You need to Insert  two line records in table
4.Take full backup of data base as mentioned on clips
Right click on the database name
Select Tasks -> Backup 
Select "full" as the backup type for taking full backup
Select "Disk" as the destination folder and select path of folder 
Click on "Add." to add a backup file and type  and click "OK" to start backup
Click "OK" again to create the backup . 

5.Now insert one more line in table.
6.Then take differential backup   as mentioned on clip

Right click on the database name
Select Tasks -> Backup 
Select "Differential" as the backup type for taking full backup
Select "Disk" as the destination folder and select path of folder 
Click on "Add." to add a backup file and type  and click "OK" to start backup
Click "OK" again to create the backup . 

7 Now delete records from table  as mentioned on clip
8.Then restore full backup
9.Now restore last differential backup to get all data with no recovery and recovery option
10 now you seen all record again.



Thanks for viewing video if you like then please subscribe.