My real name is Tracy McKibben. I’ve been working with database products for over 20 years, starting with FoxBase running on Xenix. Over the years, I’ve worked with all flavors of FoxPro, some Clipper and dBase, and starting somewhere around 1995, SQL Server. I’ve even dabbled with Oracle, though I’ve tried to block out all memories of that experience.
At present, I’m the Senior SQL Server DBA and the DBA Team Supervisor for Pearson VUE. All opinions expressed on this site are my own and do not reflect the opinions of Pearson VUE.
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.