To Whom it may concern
My backup program have given this error yesterday. We have an hourly backup running on our SQL database with SQLBackupandFTP. The data is stored in a network location called g:\IT\Backups\Hourly. Yesterday we had a brief backup failure in the morning, but after I logged on and did a manual backup in SQL Studio Manager, the problem seem to have resolved itself. Herewith the error message and also logged in Event Viewer.
SqlBackupAndFtp 5.2.1.26906 (Professional)
SUMMARY:
Database FEADAT: Backup - Failure
Database FEASYS: Backup - Failure
Database GLODAT: Backup - Failure
Database GLOSYS: Backup - Failure
Database GLOTST: Backup - Failure
Database GVGDAT: Backup - Failure
Database GVGSYS: Backup - Failure
Database KLIDAT: Backup - Failure
Database KLISYS: Backup - Failure
Database TCMDAT: Backup - Failure
Database TCMSYS: Backup - Failure
DETAILED LOG:
5/15/2019 3:00:01 PM Creating backup of FEADAT to C:\Windows\TEMP
5/15/2019 3:00:02 PM Backup of FEADAT completed
5/15/2019 3:00:02 PM Zipping C:\Windows\TEMP\FEADAT201905151500.bak to g:\IT\Backups\Hourly\FEADAT201905151500.zip
5/15/2019 3:00:03 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:00:03 PM Removing the backup: C:\Windows\TEMP\FEADAT201905151500.bak
5/15/2019 3:00:03 PM Creating backup of FEASYS to C:\Windows\TEMP
5/15/2019 3:00:03 PM Backup of FEASYS completed
5/15/2019 3:00:03 PM Zipping C:\Windows\TEMP\FEASYS201905151500.bak to g:\IT\Backups\Hourly\FEASYS201905151500.zip
5/15/2019 3:00:04 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:00:04 PM Removing the backup: C:\Windows\TEMP\FEASYS201905151500.bak
5/15/2019 3:00:04 PM Creating backup of GLODAT to C:\Windows\TEMP
5/15/2019 3:00:35 PM Backup of GLODAT completed
5/15/2019 3:00:35 PM Zipping C:\Windows\TEMP\GLODAT201905151500.bak to g:\IT\Backups\Hourly\GLODAT201905151500.zip
5/15/2019 3:01:21 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:01:21 PM Removing the backup: C:\Windows\TEMP\GLODAT201905151500.bak
5/15/2019 3:01:21 PM Creating backup of GLOSYS to C:\Windows\TEMP
5/15/2019 3:01:21 PM Backup of GLOSYS completed
5/15/2019 3:01:21 PM Zipping C:\Windows\TEMP\GLOSYS201905151501.bak to g:\IT\Backups\Hourly\GLOSYS201905151501.zip
5/15/2019 3:01:22 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:01:22 PM Removing the backup: C:\Windows\TEMP\GLOSYS201905151501.bak
5/15/2019 3:01:22 PM Creating backup of GLOTST to C:\Windows\TEMP
5/15/2019 3:01:27 PM Backup of GLOTST completed
5/15/2019 3:01:27 PM Zipping C:\Windows\TEMP\GLOTST201905151501.bak to g:\IT\Backups\Hourly\GLOTST201905151501.zip
5/15/2019 3:01:37 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:01:37 PM Removing the backup: C:\Windows\TEMP\GLOTST201905151501.bak
5/15/2019 3:01:37 PM Creating backup of GVGDAT to C:\Windows\TEMP
5/15/2019 3:01:46 PM Backup of GVGDAT completed
5/15/2019 3:01:46 PM Zipping C:\Windows\TEMP\GVGDAT201905151501.bak to g:\IT\Backups\Hourly\GVGDAT201905151501.zip
5/15/2019 3:02:02 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:02:02 PM Removing the backup: C:\Windows\TEMP\GVGDAT201905151501.bak
5/15/2019 3:02:03 PM Creating backup of GVGSYS to C:\Windows\TEMP
5/15/2019 3:02:03 PM Backup of GVGSYS completed
5/15/2019 3:02:03 PM Zipping C:\Windows\TEMP\GVGSYS201905151502.bak to g:\IT\Backups\Hourly\GVGSYS201905151502.zip
5/15/2019 3:02:03 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:02:03 PM Removing the backup: C:\Windows\TEMP\GVGSYS201905151502.bak
5/15/2019 3:02:03 PM Creating backup of KLIDAT to C:\Windows\TEMP
5/15/2019 3:02:04 PM Backup of KLIDAT completed
5/15/2019 3:02:04 PM Zipping C:\Windows\TEMP\KLIDAT201905151502.bak to g:\IT\Backups\Hourly\KLIDAT201905151502.zip
5/15/2019 3:02:06 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:02:06 PM Removing the backup: C:\Windows\TEMP\KLIDAT201905151502.bak
5/15/2019 3:02:06 PM Creating backup of KLISYS to C:\Windows\TEMP
5/15/2019 3:02:06 PM Backup of KLISYS completed
5/15/2019 3:02:06 PM Zipping C:\Windows\TEMP\KLISYS201905151502.bak to g:\IT\Backups\Hourly\KLISYS201905151502.zip
5/15/2019 3:02:06 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:02:06 PM Removing the backup: C:\Windows\TEMP\KLISYS201905151502.bak
5/15/2019 3:02:06 PM Creating backup of TCMDAT to C:\Windows\TEMP
5/15/2019 3:02:07 PM Backup of TCMDAT completed
5/15/2019 3:02:07 PM Zipping C:\Windows\TEMP\TCMDAT201905151502.bak to g:\IT\Backups\Hourly\TCMDAT201905151502.zip
5/15/2019 3:02:08 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:02:08 PM Removing the backup: C:\Windows\TEMP\TCMDAT201905151502.bak
5/15/2019 3:02:08 PM Creating backup of TCMSYS to C:\Windows\TEMP
5/15/2019 3:02:08 PM Backup of TCMSYS completed
5/15/2019 3:02:08 PM Zipping C:\Windows\TEMP\TCMSYS201905151502.bak to g:\IT\Backups\Hourly\TCMSYS201905151502.zip
5/15/2019 3:02:08 PM ERROR: Zip failed: An attempt was made to create a root folder. If the root folder is a removable drive, make sure a disk is inserted.
Type: Xceed.FileSystem.DiskFolder
FullName: g:
5/15/2019 3:02:08 PM Removing the backup: C:\Windows\TEMP\TCMSYS201905151502.bak
5/15/2019 3:02:08 PM Cleaning g:\IT\Backups\Hourly
5/15/2019 3:02:08 PM ERROR: Removing old local files failed: Could not find a part of the path ‘g:\IT\Backups\Hourly’.
Have this happened to anyone before? Is there something that I need to check on my side?
Please let me know if you require further details.
Kind Regards
Lourensvd