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.
> --
>
>
|||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[vbcol=seagreen]
> 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 -
> I
> some
>
|||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[vbcol=seagreen]
> 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 -
> 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[vbcol=seagreen]
> 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
>
|||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[vbcol=seagreen]
> 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
>
|||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[vbcol=seagreen]
> 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
>
|||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[vbcol=seagreen]
> 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
>
|||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[vbcol=seagreen]
> 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
> like
>