Incluzi calea între ghilimele:
EXEC master..xp_cmdshell 'mkdir "D:\Program Files\MSSQL\BackUp\TEST"'