SQL Server Maintenance Plan TSQL query to log the backup databases
I would recommend using these free backup (and other) scripts from http://ola.hallengren.com/

These have full logging already and have lots of other useful options.

Personally, these are what I use. Thoroughly tested and used by many, many folk.