Well, you can read the docs on the BACKUP sql statement here[^]. If you're doing a Full backup of the database, and the log doesn't get truncated already, you can follow it up with the SQL statement
BACKUP LOG databaseName TRUNCATE_ONLY
to dump the old transactions in the log that are no longer required to rebuild the database. What you're trying to maintain is a backup of the data, which you're doing daily, and a backup of the transactions in the log since the backup of the data was last done. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome -- modified at 12:31 Saturday 7th January, 2006