|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/4/2010
Posts: 5
|
Trying to backup and zip a 4.5 GB database to a local drive. Plenty of space and I can backup a smaller db, so perms not an issue.
3/4/2010 3:45:26 PM Zipping P:\TEmp BackupAndFTP\xxxxx.bak to P:\Zips BackupAndFTP\xxxxx.zip
3/4/2010 4:08:58 PM ERROR: Zip failed: An I/O exception occurred while copying the data from the item to its destination. Type: Xceed.FileSystem.DiskFile
I never see a zip file created.
Any ideas? Would like to purchase if this works.
Thx
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 610
|
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Go to "Advanced Settings" and check "Zip to the temporary folder before moving to a network location". Then try again.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/4/2010
Posts: 5
|
It attempts to zip the backup whether that setting is checked or not. The zip file is never created. Works fine on small db.
Any thoughts?
Thx - Ken
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/4/2010
Posts: 5
|
I know it won't make you rich, but if you can figure this out, I'm buying the pro version.
Thx - Ken
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Ken, I has been clean forgotten it :) Sorry about it. How much free space do you have on SYSTEM disk?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/4/2010
Posts: 5
|
Oh it might be as simple as that, let me check. Would it use that drive for caching before using the folders defined in the settings? I'll get back to you and thanks for the reply.
Ken
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Currently, we guess that a system drive should have a free space in 2-3 times more than a database
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/11/2010
Posts: 3
|
alex wrote:Currently, we guess that a system drive should have a free space in 2-3 times more than a database I'd like to revisit this as I'm currently seeing the error msg now. My database is on this particular servers D drive, I've selected the option to use a temporary folder and the temporary folder is d:\temp and I'm still seeing this error. Per above are you saying its still because of the amt of free space on the C drive of this server?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 350
|
How much free space do you have on the disc D and what are the uncompressed sizes of the databases? Make sure you have plenty of space on D. Then check the space of the target location. If you still have a problem - post your log.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/11/2010
Posts: 3
|
Last nights seem to run fine. I increased the timeout period. I'll check again tomorrow morn.
Disk space shouldn't be an issue I have 591Gb free on the drive that the sql database is on. The DB itself is 16gb uncompressed and the target has 332gb of free space.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 350
|
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 610
|
I am getting this...
SqlBackupAndFtp 5.5.0.28925 (Free)
SUMMARY:
Folder MSSQL.2: Zip - Failure
DETAILED LOG:
11/22/2010 8:00:10 PM Starting folder backup
11/22/2010 8:00:11 PM Zipping C:\Program Files\Microsoft SQL Server\MSSQL.2 to \\Gsem-mboro-dc\Data\Register Backup\MSSQL_2201011222000.zip
11/22/2010 8:00:18 PM ERROR: Zip failed: The file item could not be opened for reading.
Type: Xceed.FileSystem.DiskFile
have plenty of disk space and it does seem to be creating a zip file in the target location, but with with this error I am concerned about the integrity of the backup. Any thoughts. I am running the zip to a local location TEMP prior to it going to the network share.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 256
|
As I see you use a "folder backup" feature to backup your MS SQL databases. Propably the program can't zip the file because it's blocked by your MS SQL Server.
Please use use normal sql backup instead of folder backup to backup your SQL Server databases.
|
|
|
|
|
