Hi!

I want to setup a full sql db backup maintenance for every night and all
the transaction logs to run every hour during the day, then when the
full backup is created delete the entire log file for that day. So if I
have to restore What I have in mind if I need to restore an specific
database I just restore from the night before then the latest log file.

Can please someone advise If any steps I can follow or reading I can do
to create this maintenance plan.

Thanks for everyones help.

Jim

MS Sql Server LazyDBA home page