Sql Backup And FTP

From the log:

>>> run 8/3/2011 7:57:19 AM by Administrator

SQLBackupandFTP 6.1.0.27516 Free

SUMMARY:
Database ODrive: Backup - Failure

DETAILED LOG:
8/3/2011 7:57:18 AM Creating backup of XXXXXX to C:\WINDOWS\TEMP
8/3/2011 7:57:18 AM Backup of ODrive completed
8/3/2011 7:57:18 AM Zipping C:\WINDOWS\TEMP\XXXXXX201108030757.bak to \\W2k30002\XXX_Production_dB\XXXXXXXXX\XXXXXX201108030757.zip
8/3/2011 7:57:19 AM ERROR: Zip failed: The physical file represented by the item could not be created.
Type: Xceed.FileSystem.DiskFile
FullName: \\W2k30002\XXX_Production_dB\XXXXXXXXX\XXXXXX201108030757.zip
8/3/2011 7:57:19 AM Removing the backup: C:\WINDOWS\TEMP\XXXXXX201108030757.bak
8/3/2011 7:57:19 AM Cleaning \\W2k30002\XXX_Production_dB\XXXXXXXXX
8/3/2011 7:57:19 AM ERROR: Job finished (With Errors)

Comments?

Thanks

Thank you for the response. I enacted the change of procedure as you had suggested.

From the log:

>>> run 8/4/2011 4:24:20 PM by Administrator

SQLBackupandFTP 6.1.0.27516 Free

SUMMARY:
Database ODrive: Backup - Failure

DETAILED LOG:
8/4/2011 4:24:19 PM Creating backup of XXXXXX to C:\WINDOWS\TEMP
8/4/2011 4:24:19 PM Backup of XXXXXX completed
8/4/2011 4:24:19 PM Zipping C:\WINDOWS\TEMP\XXXXXX201108041624.bak to C:\WINDOWS\TEMP\XXXXXX201108041624.zip
8/4/2011 4:24:20 PM Zip completed (compressed size: 1,063 KB)
8/4/2011 4:24:20 PM Copying C:\WINDOWS\TEMP\XXXXXX201108041624.zip to \\W2k30002\XXX_Production_dB\XXXXXXXXX\XXXXXX201108041624.zip
8/4/2011 4:24:20 PM ERROR: Zip file copying failed: Access to the path '\\W2k30002\XXX_Production_dB\XXXXXXXXX\XXXXXX201108041624.zip' is denied.
8/4/2011 4:24:20 PM ERROR: Zip failed: Job failed
8/4/2011 4:24:20 PM Removing the backup: C:\WINDOWS\TEMP\XXXXXX201108041624.bak
8/4/2011 4:24:20 PM Removing XXXXXX201108041624.zip from C:\WINDOWS\TEMP
8/4/2011 4:24:20 PM Cleaning \\W2k30002\XXX_Production_dB\XXXXXXXXX
8/4/2011 4:24:20 PM ERROR: Job finished (With Errors)

So this looks like a permissions problem but I can successfully copy a simple text file to the area that is being denied to by the copy function of this program. ???

Thanks

Thanks for the response.
I am attempting to run it in manual mode, my thoughts being if it won't run this way it won't run in automatic mode either.

Hello

I'm testing your software on a SQL Server 2008 R2 Express edition, and I m getting an error when I'm trying to open the zip file generated after the backup task was completed. The error message is "CANNOT OPEN [Filename].zip". I already tried to open the zip file using WinRar and Windows compression utility without success.

Also, tried to restore a database using the same zip file, using your One-Click SQL Restore tool and the error message returned is the following:

---

Restore Error

---

Can't match logical files: Cannot open backup device 'C:\Users\server\AppData\Local\Temp\ocdbrtmp\altitux_yadani201110141620.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).

RESTORE FILELIST is terminating abnormally.

---

Aceptar

---

Is there any thing else that should I to check and configure additionally?

I configured the compression to lowest and normal and still the same, I havent tried highest setting.

Tested the FTP utility to copy the backup file to a remote host and works terrific.

This is important for me to be fixed so I can to decide if I buy a licence or not.

Thank you

Jose Clavel

This post had similar problem, it was because of insufficient rights

The file is in use - we can't backup it. However we should not just stop - we should backup the rest of the files. We will be making this correction very soon.