Did you know that you can create Folders with T-SQL? With the help of the built-in Extended Stored Procedure named xp_create_subdir you can. Here is a small example:
DECLARE @DBName nvarchar(100)DECLARE @Folder nvarchar(100)SET @DBName = 'TestDB'SET @Folder = 'C:TestFolder' + @DBNameEXEC master.dbo.xp_create_subdir @Folder
It goes without saying that you need to ensure that the correct permissions are set up in your SQL environment.