Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
Backup Zip File error Options · View
NineUp
#1 Posted : Wednesday, August 3, 2011 7:50:35 AM
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
mikeshilov
#2 Posted : Thursday, August 4, 2011 5:27:42 AM
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
try "zip to temporary folder before moving to network location" option in advanced settings
NineUp
#3 Posted : Thursday, August 4, 2011 3:46:34 PM
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
mikeshilov
#4 Posted : Friday, August 5, 2011 1:56:52 AM
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
do you run the job manually or in scheduled mode?
NineUp
#5 Posted : Sunday, August 7, 2011 3:54:17 AM
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.
mikeshilov
#6 Posted : Monday, August 8, 2011 11:01:50 AM
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.
Guest
#7 Posted : Friday, October 14, 2011 4:43:01 PM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,043
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
ruslan
#8 Posted : Saturday, October 15, 2011 9:33:52 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 422
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.
ruslan
#9 Posted : Tuesday, October 18, 2011 10:11:24 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 422
This post had similar problem, it was because of insufficient rights
troch
#10 Posted : Friday, December 2, 2011 9:16:39 PM
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?
ruslan
#11 Posted : Saturday, December 3, 2011 10:28:23 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 422
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.
AlexP
#12 Posted : Friday, December 30, 2011 4:29:27 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 661
We've just released SQLBackupAndFTP v6.4 with 7-zip archiving. This can solve your issue of compressing files in use.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups seopio.com ergonotes.com