How to take differential backup ? TIP #67



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

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



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s