MSSQL_NOOB (12/31/2012)
SQL Server 2000 - Full database back up at 9:00pm; transaction log backup at 12:00pm.
Backing up the log once a day? That's useless for recovery. It means you have a maximum data loss of 24 hours in the case of a disaster. If that's acceptable, switch to simple recovery and leave the log alone. If that's not acceptable, you need more frequent log backups.
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