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.
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.