472,119 Members | 1,960 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

SQL Server 2000 Backup + Restore question


Of course I'll try this before I go live, but I figured I'd ask
here first. I've read the docs, and the answer is unclear.

My current backup strategy is:

Take a full database backup occasionally (like, every two weeks).
Back up logs every five minutes.

This works, but restoring the database all the way through can
take a while, as I've sometimes spun through 800+ log restores.

I'd like to change to

Take a full database backup occasionally (like, every two weeks).
Take a differential backup every day.
Back up logs every five minutes.

So, I'd have this set of backups after day two

FULL
LOGS 1-100
DIFFERENTIAL
LOGS 101-200

When I go to restore, do I always have to do
FULL
DIFFERENTIAL
LOGS 101-200

or can I do

FULL
LOGS 1-100
LOGS 101-200?

I guess what I'm really asking is: is there any reason to keep
the "old" logs around (in this case 1-100), if I assume I always
have the latest differential?

I suppose I *might* need them to do a "point in time" restore,
i.e.
FULL
LOGS 1-53.

but assuming I never want to do that, can I discard the logs
that are earlier than my latest differential?
Sep 28 '05 #1
1 1699
Your understanding is correct - "full + all logs" or "full + diff +
logs since diff" are effectively the same thing, but as you say, using
differential backups can significantly reduce the time to restore.
Being able to do a point in time restore is the only thing you would
need the intermediate logs for, unless you want to keep them just in
case you lose or corrupt the differential backups.

Simon

Sep 29 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by datapro01 | last post: by
5 posts views Thread by Seguros Catatumbo | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.