SQLBackup and FTP Backup error


#1

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


#2

Hi Lourensvd,

Thanks for the details, but it seems you use a very old version of SQLBackupAndFTP - version 5.2.1 which is no longer supported. Sorry, but we cannot help you in resolving any issues happening with that old version.

We recommend you to upgrade your current edition to the latest release - version - 12.2.9 https://sqlbackupandftp.com/download

To upgrade your version to the latest release please go at your “My Account” https://sqlbackupandftp.com/account page and click on the Upgrade link at the “Actions” column.

Sorry for the inconvenience.