I am following best practice for SQL server VM backups by snapping the OS and SQL program file drives only, filtering out the drives that hold the databases.
So if we lose the VM, we restore the VM from snap backup, add drives and then use the SQL agent to restore the databases.
The issue we have is that to do the restore requires folders to be manually created on the newly added drives, and on some of our SQL servers with multi instances there can be a great many of these.
There doesn’t seem to be an option for the SQL restore to create the folders it needs so I had the idea of using the file agent to backup the drives, but filtering out all files, so it effectively just backs up the folders.
We could then use the file agent to restore the folder structure and the sql agent to put the databases in the folders.
I can’t quite work out though, how to filter out all files, but keep the folders.
Can anyone help?
Best answer by HyderView original