I've been using the backup script for some time and it works a treat. It is especially good for Sharepoint database servers where databases can suddenly appear as if by magic as the content grows. No need to work out names or set up jobs or keep checking for new databases, they just get included in the backup by default.

I've added a couple of extra parameters to the databasebackup proc. and added the code for them.

@Init is Y or N as to whether to backup WITH INIT or WITH NOINIT (for log files)

and @DAYFILES is Y or N for whether to use a dated file name or just the same file name each time - server space is the criteria here as backups are copied off to tape daily. I found the original dated files ate up disk space too quickly.