|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/3/2011
Posts: 3
|
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
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
try "zip to temporary folder before moving to network location" option in advanced settings
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/3/2011
Posts: 3
|
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
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
do you run the job manually or in scheduled mode?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/3/2011
Posts: 3
|
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.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
This seems to be specific to you system configuration. I don't know how we may help you here. Try to play with network paths and user accounts and/or permissions.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 937
|
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
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 417
|
Dear Jose, there are two separate problems. Most probably you can not open zip file because it is over 2GB. Use 7zip for it. Second problem with restore is separate. What SQL server version you are trying to restore to? If 2000, One-Click SQL Restore may have problems with it. Just use SSMS to restore instead.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 417
|
This post had similar problem, it was because of insufficient rights
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 12/2/2011
Posts: 1
|
I'm having a similar problem backing up the inetpub folder (and subfolders), getting this error:
SqlBackupAndFtp 6.3.0.40488 (Standard)
SUMMARY:
Folder inetpub: Zip - Failure, FTP - Failure
DETAILED LOG:
3/12/2011 2:07:08 PM Starting folder backup
3/12/2011 2:07:08 PM Zipping C:\inetpub to C:\Windows\TEMP\inetpub201112031407.zip
3/12/2011 2:07:11 PM ERROR: Zip failed: The file item could not be opened for reading.
Type: Xceed.FileSystem.DiskFile
FullName: C:\inetpub\logs\LogFiles\W3SVC3\u_ex111203.log
3/12/2011 2:07:11 PM Removing inetpub201112031407.zip from C:\Windows\TEMP
Can you please help me to resolve this error?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 417
|
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.
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 419
|
We've just released SQLBackupAndFTP v6.4 with 7-zip archiving. This can solve your issue of compressing files in use.
|
|
|
|
|
