Prev: Is database available during a backup?
Next: Strategy for data partition?
From: Steve Gr on 29 Jun 2010 11:44
Hi,

If I do a full backup on a SQL 2000 database, then backup the transaction
log several times over a few hours, then do a differential backup, what do I
need if I then want to restore that database?

Do I just need the full and the diff?
Or do I need all the logs in between as well?

Thanks in Advance,
Steve


From: Tom Cooper on 29 Jun 2010 13:02
To recover to the point in time the diff was taken, you just need the full
and the diff.

Tom

"Steve Gr" <MSDNNospam235(a)nospam.nospam> wrote in message
news:uYKB1H6FLHA.4060(a)TK2MSFTNGP04.phx.gbl...
> Hi,
>
> If I do a full backup on a SQL 2000 database, then backup the transaction
> log several times over a few hours, then do a differential backup, what do
> I need if I then want to restore that database?
>
> Do I just need the full and the diff?
> Or do I need all the logs in between as well?
>
> Thanks in Advance,
> Steve
>

From: Dan Guzman on 30 Jun 2010 08:39
To add to Tom's response, the basic restore sequence to minimize data loss
is:

1) restore last full backup
2) restore most recent differential
3) restore logs since most recent differential

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Steve Gr" <MSDNNospam235(a)nospam.nospam> wrote in message
news:uYKB1H6FLHA.4060(a)TK2MSFTNGP04.phx.gbl...
> Hi,
>
> If I do a full backup on a SQL 2000 database, then backup the transaction
> log several times over a few hours, then do a differential backup, what do
> I need if I then want to restore that database?
>
> Do I just need the full and the diff?
> Or do I need all the logs in between as well?
>
> Thanks in Advance,
> Steve
>
From: Steve Gr on 30 Jun 2010 09:04
Thanks for your help and advice, guys.
Steve

"Dan Guzman" <guzmanda(a)nospam-online.sbcglobal.net> wrote in message
news:57E4A0FB-4663-4ECD-A542-FA4F3DD9C112(a)microsoft.com...
> To add to Tom's response, the basic restore sequence to minimize data loss
> is:
>
> 1) restore last full backup
> 2) restore most recent differential
> 3) restore logs since most recent differential
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
> http://weblogs.sqlteam.com/dang/
>
> "Steve Gr" <MSDNNospam235(a)nospam.nospam> wrote in message
> news:uYKB1H6FLHA.4060(a)TK2MSFTNGP04.phx.gbl...
>> Hi,
>>
>> If I do a full backup on a SQL 2000 database, then backup the transaction
>> log several times over a few hours, then do a differential backup, what
>> do I need if I then want to restore that database?
>>
>> Do I just need the full and the diff?
>> Or do I need all the logs in between as well?
>>
>> Thanks in Advance,
>> Steve
>>


 | 
Pages: 1
Prev: Is database available during a backup?
Next: Strategy for data partition?