T-SQL To Check For Directories

I needed to use T-SQL to check for backup folders and create them if missing.  Yes, I would normally use Powershell, but I'm saving up a rant for later on that topic... This script by Jugal Shah worked quite well.  Combined with Aaron Bertrand's sp_ForEachDb, you can easily find and create missing backup directories.  For…

Advertisement