Can't compress (zip) DB backup - please help.

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.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
"Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
news:uPOxN3QXEHA.2636@.TK2MSFTNGP10.phx.gbl...
> 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.
> --
>
>|||Yes, I have checked - I have compressed successfully and larger files than
3Gb. It seems somthing like SQL Server keeps backup locked for read...
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:%23RdPwZSXEHA.2408@.tk2msftngp13.phx.gbl...
> 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
> "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> news:uPOxN3QXEHA.2636@.TK2MSFTNGP10.phx.gbl...
is[vbcol=seagreen]
> (Send
too -[vbcol=seagreen]
> I
> some
>|||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
"Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
news:%23Mvdt1ZXEHA.3284@.TK2MSFTNGP12.phx.gbl...
> Yes, I have checked - I have compressed successfully and larger files
than
> 3Gb. It seems somthing like SQL Server keeps backup locked for read...
> --
>
> "Peter Yeoh" <nospam@.nospam.com> wrote in message
> news:%23RdPwZSXEHA.2408@.tk2msftngp13.phx.gbl...
files[vbcol=seagreen]
supports[vbcol=seagreen]
you[vbcol=seagreen]
> to
> is
error -[vbcol=seagreen]
> too -
PkZip[vbcol=seagreen]
>|||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.
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:uU3AyHaXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> 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
>
> "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> news:%23Mvdt1ZXEHA.3284@.TK2MSFTNGP12.phx.gbl...
> than
> files
> supports
WinRar[vbcol=seagreen]
> you
Backup[vbcol=seagreen]
file[vbcol=seagreen]
> error -
> PkZip
like[vbcol=seagreen]
>|||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
"Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
news:u23OqVaXEHA.3664@.TK2MSFTNGP12.phx.gbl...
> 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.
> --
>
> "Peter Yeoh" <nospam@.nospam.com> wrote in message
> news:uU3AyHaXEHA.1656@.TK2MSFTNGP09.phx.gbl...
and[vbcol=seagreen]
> I
delete[vbcol=seagreen]
> WinRar
allows[vbcol=seagreen]
> Backup
> file
permissions[vbcol=seagreen]
> like
>|||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
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:%233wsj%23aXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> 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
>
> "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> news:u23OqVaXEHA.3664@.TK2MSFTNGP12.phx.gbl...
> that
it[vbcol=seagreen]
> is
> and
in[vbcol=seagreen]
> delete
files[vbcol=seagreen]
read...[vbcol=seagreen]
support[vbcol=seagreen]
> allows
backup[vbcol=seagreen]
> permissions
too.[vbcol=seagreen]
sounds[vbcol=seagreen]
>|||Glad it worked out for you.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
news:uaBSea1XEHA.2972@.TK2MSFTNGP12.phx.gbl...
> 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
> --
>
> "Peter Yeoh" <nospam@.nospam.com> wrote in message
> news:%233wsj%23aXEHA.1888@.TK2MSFTNGP11.phx.gbl...
you[vbcol=seagreen]
mentioned[vbcol=seagreen]
> it
it[vbcol=seagreen]
Gig[vbcol=seagreen]
> in
> files
> read...
> support
it[vbcol=seagreen]
believe[vbcol=seagreen]
database.[vbcol=seagreen]
> backup
folder[vbcol=seagreen]
> too.
> sounds
answer.[vbcol=seagreen]
>sql