Database Recovery Plan

Hi everyone,

I am trying to implement a plan for a SQL7 database that is used by the company I work for. Having read the SQL manuals I have come to the following conclusion:

I want to do a complete backup of the database at midnight and do a transaction log backup every 30 minutes between 7am and 7pm. I am hoping this will allow me to 'undo' any user mistakes and roll back the database changes to the last transaction log backup.

The questions I have are:

1) By backing up the transaction log every 30 minutes, will this then give me the ability to 'roll back' the database to the last time the transaction log was backed up (i.e. 30 minutes max) ?

2) How do I load the transaction log back in ? (i.e roll the database changes back). A simple Restore operation (with truncate ???)

3)Am I totally confused or on the right track ?

Thanks,

Tim