Beatrix Kiddo (2/12/2013)
5) Schedule a regular backup of the transaction log, with overwritewill that work ok and solve my problem?
As long as you never want to restore that log backup, as it will be completely useless....
Please read through this - Managing Transaction Logs[/url]
Log backups form a chain, to restore to a point in time you need all the log backups from the full that you're using to the point you're restoring to, not the last one.
Set your backups to back up to individual files, preferably with the date as part of the name.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability