This stored procedure will backup all databases on a server when run with a SQL job. I have it run nightly as it will also delete old backups depending on the retention period. A table DatabaseBackup is maintained to allow the changing of the retention period or exclusion of a database. ... [More]