Full Database Back and Diffrential Database Backup

I have one full database back and 4 differential database backup.
(Recovery model is simple) In the recovery process, I have restored the
full database backup with No_recovery option. After that should i
restore all the 4 differential backup or the most recent differential
backup? Please explain.
RegardsHi
http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting best practices
"Praveen" <apveen@.gmail.com> wrote in message
news:1143010815.337892.295070@.e56g2000cwe.googlegroups.com...
>I have one full database back and 4 differential database backup.
> (Recovery model is simple) In the recovery process, I have restored the
> full database backup with No_recovery option. After that should i
> restore all the 4 differential backup or the most recent differential
> backup? Please explain.
> Regards
>|||You have to restore first full backup and latest differential backup
you have taken after last full backup.
Regards
Amish Shah|||thank you for your replay. but i have a doubt. how only full database
backup and most recent diffrentail backup is enough to recover the
database?. why the intermediate diffrential backups are not required?.
Internally what is happening?.
BOL does not specify the backgroud process of recovery process while
applying the diffrential backup after full database back up?.|||Differential backups always store the changes from the last FULL backup. So
the previous Differential backups are not needed only the last one.
Andrew J. Kelly SQL MVP
"Praveen" <apveen@.gmail.com> wrote in message
news:1143029248.422816.10680@.j33g2000cwa.googlegroups.com...
> thank you for your replay. but i have a doubt. how only full database
> backup and most recent diffrentail backup is enough to recover the
> database?. why the intermediate diffrential backups are not required?.
> Internally what is happening?.
> BOL does not specify the backgroud process of recovery process while
> applying the diffrential backup after full database back up?.
>|||I got the answer from this link
http://msdn2.microsoft.com/en-us/library/ms345448(SQL.90).aspx
thanks for all.