I am taking a look into Sql Backup and FTP as a solution for my companies backup needs and I am having some issues getting the scheduled backup working.
Currently I am running a backup to network folder. I am able to run the backup manually and all goes as expected, but as soon as it tries to run a scheduled backup it fails.
I saw
here that someone else was having a similar issue but it looks like their issue was fixed in 6.1.7. I am currently running 6.2.
Here is the LOG I am receiving for the failed backup notification:
DETAILED LOG:
11/16/2011 11:09:02 AM Creating backup of DBNAME to C:\Windows\TEMP
11/16/2011 11:09:03 AM Backup of DBNAME completed
11/16/2011 11:09:03 AM Zipping C:\Windows\TEMP\DBNAME201111161109.bak to \\SERVER\FOLDER\DBNAME201111161109.zip
11/16/2011 11:09:05 AM 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: \\SERVER\FOLDER\
11/16/2011 11:09:05 AM Removing the backup: C:\Windows\TEMP\DBNAME201111161109.bak
11/16/2011 11:09:05 AM Cleaning \\SERVER\FOLDER\
11/16/2011 11:09:05 AM WARNING: Removing old local files failed: Logon failure: unknown user name or bad password.
Thanks
