Backup strategy question

[OldSkoolSkater]

Hello again

I have implemented the following backup strategy for our SQL 7 server:
Full - Sun, Wed
Diff - Mon, Tue, Thur, Fri, Sat
Trans - Hourly, keeping the last 24 hours worth of logs.

My question is:
Do I need to keep more transaction logs?
If my d/b dies then it is my understanding that I would restore the last full backup, followed by the last diff backup, followed by all transaction logs from that backup up to the point in time that I want restored to.
Please clarify what I am doing is correct!

 

[RickCole]

Yes you are correct in what you are saying. I think every site I have come across has a slightly different backup strategy but yours is a correct solution.

I would run a few simulated failures and test out your strategy so you feel very comfortable in carrying out the procedure. Nothing worse then finding out you have a hole some where when it's happening for real.

Rick.