Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
ERROR: Zip failed: The file item could not be opened for reading. Options · View
Guest
#1 Posted : Thursday, January 13, 2011 9:44:09 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
Hi All,

Just came across SQL Backup and FTP and it is almost exactly what I've been looking for. I've only found one issue that is preventing me from buying a copy.

The application seems to be backing up my databases fine, but I was also trying to use the file backup option as well.

The problem is I get the following error:
1/13/2011 7:34:14 PM Zipping C:\HostingSpaces to C:\Windows\TEMP\HostingSpaces201101131934.zip
1/13/2011 7:34:14 PM ERROR: Zip failed: The file item could not be opened for reading.
Type: Xceed.FileSystem.DiskFile
FullName: C:\HostingSpaces\mywebsite\mywebsite.com.au\logs\W3SVC8\u_ex110114.log

The reason for this I think is that the directory structure I have is as follows:
C:\HostingSpaces - contains all websites
--> \mywebsite - contains a specific website
----> \data - contains datafiles, e.g. Access databases etc
----> \ wwwroot - contains site files
----> \logs - contains copies of IIS logs

The issue is the IIS log files are locked and when SQLBackupAndFTP comes to read then, it fails.

It would be great if there was some sort of function to exclude certain types of files etc.

Unfortunately I can't change my file structure. The only way around it is for me to specify each of the wwwroot directories for each site, but that means a lot more manual work.

What is everyones thoughts?
ruslan
#2 Posted : Friday, January 14, 2011 1:34:29 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
It seems correct that the files are locked and that's the reason of the error.
File backup is just a small auxiliary feature of SQLBackupAndFTP to save the trouble of using another program for file backup.
This feature is secondary to our product and in any complicated scenario like yours you are better off use one of many programs designed specifically for file backup.
We have no plans to make file backup any more complicated than it is right now. SQL is our focus.
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can 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.