I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent jobs to perform its tasks, instead of running dynamic SQL statements. This makes the process much more resilient when it comes to handling errors – one failed backup can’t disrupt the entire process.

I also added an additional parameter to help with low disk space situations, and fixed a bug that prevented the procedure from working with SQL 2005. See the details and grab the code from the sp_BackupDatabases download page.

The post sp_BackupDatabases v1.2 appeared first on RealSQLGuy.