We were discussing backup from last few post. Now lets take a look one more feature of backup which is differential backup.
Differential backup is backup after last full backup. Before taking Differential backup it is a mandatory condition to take full backup.
Differential backup can speed up your recovery process or we can say restore process.
In below example we would understand how to take differential backup
To take differential backup we can run following command
BACKUP DATABASE IndiandotnetDB
TO DISK = ‘D:\IndiandotnetDB.dif’
Or we can take differential backup by following steps also
Right click the database select database backup option you will get same screen which we explain at the time of full backup.
if you see below screen you will find we have change backup type to Differential and taking backup to d drive with name Indiandotnetdb.dif
Once you click OK button. your differential backup will be completed.
I hope this tip might help you somewhere.
Thanks & Enjoy!!!