how to use differential backups

I have a question on how to restore a database that used differential
backups. I could not find the answer addressed specifically in BOL. If
there were multiple diff backups since the last full backup or trans log
backup….do the diff backups get restored in sequence they were taken or do
es
just the last one need restored?
thanksJust the last differential. So you'd restore the full backup, the last
differential then any subsequent logs.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Just the last one.
Assuming
Monday Full1
Tuesday Diff1
Wed Tx1
Thu Diff2
Fri Diff3
Sat Tx2
Sun Tx3
Restore Full1, Diff3, Tx2, Tx3
"jason" <jason@.discussions.microsoft.com> wrote in message
news:A8D0B00D-1617-45AE-91A7-4B237CAC66F2@.microsoft.com...
>I have a question on how to restore a database that used differential
> backups. I could not find the answer addressed specifically in BOL. If
> there were multiple diff backups since the last full backup or trans log
> backup..do the diff backups get restored in sequence they were taken or
> does
> just the last one need restored?
> thanks|||thanks
"Paul Ibison" wrote:

> Just the last differential. So you'd restore the full backup, the last
> differential then any subsequent logs.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>|||thanks!
"Bill Edwards" wrote:

> Just the last one.
>
> Assuming
> Monday Full1
> Tuesday Diff1
> Wed Tx1
> Thu Diff2
> Fri Diff3
> Sat Tx2
> Sun Tx3
> Restore Full1, Diff3, Tx2, Tx3
>
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:A8D0B00D-1617-45AE-91A7-4B237CAC66F2@.microsoft.com...
>
>|||Add on to that.
1. Restore with NORECOVERY on full database backup
2. Restore with NORECOVERY on diff database backup
3. Restore with NORECOVERY on all log backups until last file
4. Restore WITH RECOVERY on last Log backup. This will make database online.
Thanks
Hari
"jason" <jason@.discussions.microsoft.com> wrote in message
news:F4CA94AF-CD87-4384-A917-D7A30DB4EE12@.microsoft.com...[vbcol=seagreen]
> thanks!
> "Bill Edwards" wrote:
>