How to take database backup?
When we take backup of a database. We have a option of
Recovery Model. Which won’t be editable for now. We are going to learn how we
can switch/change the recovery model.
Generally there are three kind of recovery model
To change recovery model
STEP 1: Right Click on database select properties.
STEP 2: In the new window select Options from left hand side
and then you will find the recovery model dropdown. Select anyone of them of
your choice and then click OK.
We are going to learn more in detail what are these recovery models.