|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/8/2010
Posts: 2
|
I have backups scheduled using the "None" Zip compression level because I use another remote backup software to backup the files offsite and it makes it easier if they are uncompressed because that software uses Delta backups. It saves the backups with a .zip extension and when you try to unzip it with both Windows and Winzip it says the file is corrupt. Since it isn't compressed I tried just changing the extension from .zip to .bak but then SSMS gives an error when trying to restore the db.  I checked two weeks worth of backups and they all are the same. I have another good backup, but I'm just worried about a future restore. Any ideas? Thanks. Ruben
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 416
|
Most probably your zip size is over 2GB and windows can't handle it. You need to use 7zip or similar. Please reply if this assumption is accurate.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 937
|
No, the backup size is only about 130 MB. It is on Windows 2008 Server.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 8/8/2010
Posts: 2
|
Also, forgot to mention, I tested using Low compression and it unzips fine and I am able to restore in SSMS.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 416
|
It seems you have discovered a bug with None compression option. Give me a couple a days to investigate.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 416
|
Yep, it's a bug. Thank you very much for pointing this out. In the next few days we will release an updated version that won't compress .bak file at all if "None" option is selected in Compression Settings. You can check this page for a new version: http://www.sqlbackupandftp.com/download/
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 416
|
The problem is fixed in v5.1 - live now.
If in advanced settings zip compression level "None" is selected, the database backup will be saved just as unencrypted .bak file. Folders and scripts will still be zipped with lowest compression.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 937
|
I am using version 6.0 and none is selected in advanced options for compression, so it will save to a .bak file if FAILS.
Its zips it all up and makes .sql files. Then the restore tool fails to use .sql but only .bak. So this is is for nothing if I can get a .bak file to use to restore.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 416
|
The confusion is because you are using remote backups http://www.sqlbackupandftp.com/remote/Install SBF on the same server and you won't have any of these issues
|
|
|
|
|
