managing sql log files - recommendations please

Do you have any transaction log backup scheduled? If affirmative, how often it runs?

Hi Vitor
No I have nothing like this

Ditto to Vitor's comments.

You first need to decide, at a business level, how long a period of time you can afford to lose data for.  But be realistic, as the shorter the time frame, the more work it is on the database side. That decision will determine whether or not you need to backup log files, or if you can go to simple mode and skip the log backups completely.

For example, if you decide you just need a database backup no more often than, say, every six hours, meaning you could lose all activity between each backup, put the db in simple mode and do a full backup that often (for a db of only 3gb, I don't see a need to mess with differential backups at that time range).

If you decide on less than six hours, say, then you could use either differential backups, as above, or use full recovery model, including regularly scheduled log backups, or a mix of the two.  In that case, you would also need to do some "practice" recoveries using log files, since applying log files to a backup takes some getting used to.

Thanks all
We need FULL

and I need to keep the last 1 month and ideally I would like to keep as much new data as possible,  but I guess if I had to choose a number I could loose the last 30 mins

Does that mean I need to do a full backup (.Bak) every month,  and then do differental every 30 mins?

Full backup every week.  Differential backup every 12 hours (or however many hours you prefer).  Tran log backup every 30 minutes.

Great thanks
Do I delete the bak file every week and only keep latest?

Do I do the same with differential etc