Discussion:
Can't compress (zip) DB backup - please help.
(too old to reply)
Marko S
2004-06-28 12:51:14 UTC
Permalink
I am doing Backup - zip - ftp - unzip - restore of my database. Backup is
allways done without problems, but when I am trying to zip backup file (Send
to > Compressed Zip folder) I get the message "Compressed folder error -
file not found or no read permission" !!
However, I file IS there - it have about 3Gb. I have all permissions too - I
can rename or delete it. I have tried to compress with pkzip too. PkZip
succeeds, but then it is impossible to unzip that file. It sounds like some
security problem.

All that happens on:
- Windows 2003
- SQL Server 2000

Please help - give me just fingerpost where to look for answer.

--
Peter Yeoh
2004-06-28 15:50:08 UTC
Permalink
Whichever compression program you are using, check that they support files
larger than 2 Gig. If using WinZip, use the latest version as it supports
the Zip64 format, which handles files > 2 Gig in size. I believe WinRar
also supports files > 2 Gig. Not sure about PkZip.

Alternatively, you could try our product, MiniSQLBackup, which allows you to
create and restore directly to/from compressed files.

Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
Post by Marko S
I am doing Backup - zip - ftp - unzip - restore of my database. Backup is
allways done without problems, but when I am trying to zip backup file (Send
to > Compressed Zip folder) I get the message "Compressed folder error -
file not found or no read permission" !!
However, I file IS there - it have about 3Gb. I have all permissions too - I
can rename or delete it. I have tried to compress with pkzip too. PkZip
succeeds, but then it is impossible to unzip that file. It sounds like some
security problem.
- Windows 2003
- SQL Server 2000
Please help - give me just fingerpost where to look for answer.
--
Marko S
2004-06-29 05:59:26 UTC
Permalink
Yes, I have checked - I have compressed successfully and larger files than
3Gb. It seems somthing like SQL Server keeps backup locked for read...
--
Post by Peter Yeoh
Whichever compression program you are using, check that they support files
larger than 2 Gig. If using WinZip, use the latest version as it supports
the Zip64 format, which handles files > 2 Gig in size. I believe WinRar
also supports files > 2 Gig. Not sure about PkZip.
Alternatively, you could try our product, MiniSQLBackup, which allows you to
create and restore directly to/from compressed files.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
Post by Marko S
I am doing Backup - zip - ftp - unzip - restore of my database. Backup is
allways done without problems, but when I am trying to zip backup file
(Send
Post by Marko S
to > Compressed Zip folder) I get the message "Compressed folder error -
file not found or no read permission" !!
However, I file IS there - it have about 3Gb. I have all permissions
too -
Post by Peter Yeoh
I
Post by Marko S
can rename or delete it. I have tried to compress with pkzip too. PkZip
succeeds, but then it is impossible to unzip that file. It sounds like
some
Post by Marko S
security problem.
- Windows 2003
- SQL Server 2000
Please help - give me just fingerpost where to look for answer.
--
Peter Yeoh
2004-06-29 06:27:18 UTC
Permalink
Ok, you mean the built-in windows explorer compressor. I've tried it and I
get the same error whenever I try to compress ANY single file > 2 Gig in
size. The backup file can't possibly be locked if you can rename / delete
it as you mentioned in your first post.

Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
Post by Marko S
Yes, I have checked - I have compressed successfully and larger files than
3Gb. It seems somthing like SQL Server keeps backup locked for read...
--
Post by Peter Yeoh
Whichever compression program you are using, check that they support files
larger than 2 Gig. If using WinZip, use the latest version as it supports
the Zip64 format, which handles files > 2 Gig in size. I believe WinRar
also supports files > 2 Gig. Not sure about PkZip.
Alternatively, you could try our product, MiniSQLBackup, which allows
you
Post by Marko S
to
Post by Peter Yeoh
create and restore directly to/from compressed files.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
Post by Marko S
I am doing Backup - zip - ftp - unzip - restore of my database. Backup
is
Post by Peter Yeoh
Post by Marko S
allways done without problems, but when I am trying to zip backup file
(Send
Post by Marko S
to > Compressed Zip folder) I get the message "Compressed folder error -
file not found or no read permission" !!
However, I file IS there - it have about 3Gb. I have all permissions
too -
Post by Peter Yeoh
I
Post by Marko S
can rename or delete it. I have tried to compress with pkzip too. PkZip
succeeds, but then it is impossible to unzip that file. It sounds like
some
Post by Marko S
security problem.
- Windows 2003
- SQL Server 2000
Please help - give me just fingerpost where to look for answer.
--
Marko S
2004-06-29 06:56:36 UTC
Permalink
Yes I know it can't be locked if I can rename / delete it - I mentioned that
because it is weird.
I don't get this error when compressing another file that have 6.2Gb - it is
compressed and decompressed OK.
--
Post by Peter Yeoh
Ok, you mean the built-in windows explorer compressor. I've tried it and I
get the same error whenever I try to compress ANY single file > 2 Gig in
size. The backup file can't possibly be locked if you can rename / delete
it as you mentioned in your first post.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
Post by Marko S
Yes, I have checked - I have compressed successfully and larger files
than
Post by Marko S
3Gb. It seems somthing like SQL Server keeps backup locked for read...
--
Post by Peter Yeoh
Whichever compression program you are using, check that they support
files
Post by Marko S
Post by Peter Yeoh
larger than 2 Gig. If using WinZip, use the latest version as it
supports
Post by Marko S
Post by Peter Yeoh
the Zip64 format, which handles files > 2 Gig in size. I believe WinRar
also supports files > 2 Gig. Not sure about PkZip.
Alternatively, you could try our product, MiniSQLBackup, which allows
you
Post by Marko S
to
Post by Peter Yeoh
create and restore directly to/from compressed files.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
Post by Marko S
I am doing Backup - zip - ftp - unzip - restore of my database. Backup
is
Post by Peter Yeoh
Post by Marko S
allways done without problems, but when I am trying to zip backup file
(Send
Post by Marko S
to > Compressed Zip folder) I get the message "Compressed folder
error -
Post by Marko S
Post by Peter Yeoh
Post by Marko S
file not found or no read permission" !!
However, I file IS there - it have about 3Gb. I have all permissions
too -
Post by Peter Yeoh
I
Post by Marko S
can rename or delete it. I have tried to compress with pkzip too.
PkZip
Post by Marko S
Post by Peter Yeoh
Post by Marko S
succeeds, but then it is impossible to unzip that file. It sounds like
some
Post by Marko S
security problem.
- Windows 2003
- SQL Server 2000
Please help - give me just fingerpost where to look for answer.
--
Peter Yeoh
2004-06-29 08:05:20 UTC
Permalink
Sorry, I have no idea what may be wrong, though I'll be interested if you
find out why.

Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
Post by Marko S
Yes I know it can't be locked if I can rename / delete it - I mentioned that
because it is weird.
I don't get this error when compressing another file that have 6.2Gb - it is
compressed and decompressed OK.
--
Post by Peter Yeoh
Ok, you mean the built-in windows explorer compressor. I've tried it
and
Post by Marko S
I
Post by Peter Yeoh
get the same error whenever I try to compress ANY single file > 2 Gig in
size. The backup file can't possibly be locked if you can rename / delete
it as you mentioned in your first post.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
Post by Marko S
Yes, I have checked - I have compressed successfully and larger files
than
Post by Marko S
3Gb. It seems somthing like SQL Server keeps backup locked for read...
--
Post by Peter Yeoh
Whichever compression program you are using, check that they support
files
Post by Marko S
Post by Peter Yeoh
larger than 2 Gig. If using WinZip, use the latest version as it
supports
Post by Marko S
Post by Peter Yeoh
the Zip64 format, which handles files > 2 Gig in size. I believe
WinRar
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
also supports files > 2 Gig. Not sure about PkZip.
Alternatively, you could try our product, MiniSQLBackup, which allows
you
Post by Marko S
to
Post by Peter Yeoh
create and restore directly to/from compressed files.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
Post by Marko S
I am doing Backup - zip - ftp - unzip - restore of my database.
Backup
Post by Peter Yeoh
Post by Marko S
is
Post by Peter Yeoh
Post by Marko S
allways done without problems, but when I am trying to zip backup
file
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
(Send
Post by Marko S
to > Compressed Zip folder) I get the message "Compressed folder
error -
Post by Marko S
Post by Peter Yeoh
Post by Marko S
file not found or no read permission" !!
However, I file IS there - it have about 3Gb. I have all permissions
too -
Post by Peter Yeoh
I
Post by Marko S
can rename or delete it. I have tried to compress with pkzip too.
PkZip
Post by Marko S
Post by Peter Yeoh
Post by Marko S
succeeds, but then it is impossible to unzip that file. It sounds
like
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
some
Post by Marko S
security problem.
- Windows 2003
- SQL Server 2000
Please help - give me just fingerpost where to look for answer.
--
Marko S
2004-07-01 10:37:40 UTC
Permalink
Now, I have tried with GZIP and it works OK. So, it could be because of
impotence of PKZip 2.5 and Compressor under Windows 2003 to compress files
larger than 2Gb. Strage bahaviour, because it work fine with Win2003 compr.
and file size 6,2 Gb.
However, with GZIP it works fine...

Thanks for answers Peter.

Regards,
Marko S
--
Post by Peter Yeoh
Sorry, I have no idea what may be wrong, though I'll be interested if you
find out why.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
Post by Marko S
Yes I know it can't be locked if I can rename / delete it - I mentioned
that
Post by Marko S
because it is weird.
I don't get this error when compressing another file that have 6.2Gb -
it
Post by Peter Yeoh
is
Post by Marko S
compressed and decompressed OK.
--
Post by Peter Yeoh
Ok, you mean the built-in windows explorer compressor. I've tried it
and
Post by Marko S
I
Post by Peter Yeoh
get the same error whenever I try to compress ANY single file > 2 Gig in
size. The backup file can't possibly be locked if you can rename /
delete
Post by Marko S
Post by Peter Yeoh
it as you mentioned in your first post.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
Post by Marko S
Yes, I have checked - I have compressed successfully and larger files
than
Post by Marko S
3Gb. It seems somthing like SQL Server keeps backup locked for read...
--
Post by Peter Yeoh
Whichever compression program you are using, check that they support
files
Post by Marko S
Post by Peter Yeoh
larger than 2 Gig. If using WinZip, use the latest version as it
supports
Post by Marko S
Post by Peter Yeoh
the Zip64 format, which handles files > 2 Gig in size. I believe
WinRar
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
also supports files > 2 Gig. Not sure about PkZip.
Alternatively, you could try our product, MiniSQLBackup, which
allows
Post by Marko S
Post by Peter Yeoh
you
Post by Marko S
to
Post by Peter Yeoh
create and restore directly to/from compressed files.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
Post by Marko S
I am doing Backup - zip - ftp - unzip - restore of my database.
Backup
Post by Peter Yeoh
Post by Marko S
is
Post by Peter Yeoh
Post by Marko S
allways done without problems, but when I am trying to zip backup
file
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
(Send
Post by Marko S
to > Compressed Zip folder) I get the message "Compressed folder
error -
Post by Marko S
Post by Peter Yeoh
Post by Marko S
file not found or no read permission" !!
However, I file IS there - it have about 3Gb. I have all
permissions
Post by Marko S
Post by Peter Yeoh
Post by Marko S
too -
Post by Peter Yeoh
I
Post by Marko S
can rename or delete it. I have tried to compress with pkzip too.
PkZip
Post by Marko S
Post by Peter Yeoh
Post by Marko S
succeeds, but then it is impossible to unzip that file. It sounds
like
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
some
Post by Marko S
security problem.
- Windows 2003
- SQL Server 2000
Please help - give me just fingerpost where to look for answer.
--
Peter Yeoh
2004-07-02 01:18:41 UTC
Permalink
Glad it worked out for you.

Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
Post by Marko S
Now, I have tried with GZIP and it works OK. So, it could be because of
impotence of PKZip 2.5 and Compressor under Windows 2003 to compress files
larger than 2Gb. Strage bahaviour, because it work fine with Win2003 compr.
and file size 6,2 Gb.
However, with GZIP it works fine...
Thanks for answers Peter.
Regards,
Marko S
--
Post by Peter Yeoh
Sorry, I have no idea what may be wrong, though I'll be interested if you
find out why.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
Post by Marko S
Yes I know it can't be locked if I can rename / delete it - I mentioned
that
Post by Marko S
because it is weird.
I don't get this error when compressing another file that have 6.2Gb -
it
Post by Peter Yeoh
is
Post by Marko S
compressed and decompressed OK.
--
Post by Peter Yeoh
Ok, you mean the built-in windows explorer compressor. I've tried it
and
Post by Marko S
I
Post by Peter Yeoh
get the same error whenever I try to compress ANY single file > 2
Gig
Post by Marko S
in
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
size. The backup file can't possibly be locked if you can rename /
delete
Post by Marko S
Post by Peter Yeoh
it as you mentioned in your first post.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
Post by Marko S
Yes, I have checked - I have compressed successfully and larger
files
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
than
Post by Marko S
3Gb. It seems somthing like SQL Server keeps backup locked for
read...
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
Post by Marko S
--
Post by Peter Yeoh
Whichever compression program you are using, check that they
support
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
files
Post by Marko S
Post by Peter Yeoh
larger than 2 Gig. If using WinZip, use the latest version as it
supports
Post by Marko S
Post by Peter Yeoh
the Zip64 format, which handles files > 2 Gig in size. I believe
WinRar
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
also supports files > 2 Gig. Not sure about PkZip.
Alternatively, you could try our product, MiniSQLBackup, which
allows
Post by Marko S
Post by Peter Yeoh
you
Post by Marko S
to
Post by Peter Yeoh
create and restore directly to/from compressed files.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
Post by Marko S
I am doing Backup - zip - ftp - unzip - restore of my database.
Backup
Post by Peter Yeoh
Post by Marko S
is
Post by Peter Yeoh
Post by Marko S
allways done without problems, but when I am trying to zip
backup
Post by Peter Yeoh
Post by Marko S
file
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
(Send
Post by Marko S
to > Compressed Zip folder) I get the message "Compressed folder
error -
Post by Marko S
Post by Peter Yeoh
Post by Marko S
file not found or no read permission" !!
However, I file IS there - it have about 3Gb. I have all
permissions
Post by Marko S
Post by Peter Yeoh
Post by Marko S
too -
Post by Peter Yeoh
I
Post by Marko S
can rename or delete it. I have tried to compress with pkzip
too.
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
PkZip
Post by Marko S
Post by Peter Yeoh
Post by Marko S
succeeds, but then it is impossible to unzip that file. It
sounds
Post by Peter Yeoh
Post by Marko S
like
Post by Peter Yeoh
Post by Marko S
Post by Peter Yeoh
some
Post by Marko S
security problem.
- Windows 2003
- SQL Server 2000
Please help - give me just fingerpost where to look for answer.
--
Loading...