tag:blogger.com,1999:blog-8305675988893866325.post595593771453786421..comments2024-01-14T05:09:01.338-08:00Comments on Algae Education Services: Copy all files from one drive to other via SQL Server Script using RobocopyAlgae Educationhttp://www.blogger.com/profile/12443040604753343283noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8305675988893866325.post-61795348253117169802014-07-11T06:16:03.547-07:002014-07-11T06:16:03.547-07:00True , but this script first find the file list sa...True , but this script first find the file list save it and then copy. The only chance is if some one delete file just after my script make list of files.Saurabh Sinhahttps://www.blogger.com/profile/11120038651556545818noreply@blogger.comtag:blogger.com,1999:blog-8305675988893866325.post-39675897206839520222014-05-02T13:12:48.859-07:002014-05-02T13:12:48.859-07:00the only problem with xp_cmdshell is that it does ...the only problem with xp_cmdshell is that it does not return an error if it encounters a file system error (e.g. file does not exist).Unknownhttps://www.blogger.com/profile/06738772925394876073noreply@blogger.com