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...
> > 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.
> >
> > --
> >
> >
> >
> >
>|||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...
> > 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 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...
> > 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...
> > > > 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.
> > > >
> > > > --
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||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...
> > 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...
> > > > 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.
> > > > >
> > > > > --
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||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...
> > 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...
> > > > 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...
> > > > > > 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.
> > > > > >
> > > > > > --
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||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...
> > 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...
> > > > 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...
> > > > > > 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.
> > > > > > >
> > > > > > > --
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>