Copy all files from one drive to other via SQL Server Script xp_cmdshell

Copy all files from one drive to other via SQL Server Script using Robocopy

SQL Server ACID Properties