Problems with DB Backups

Discussion in 'Databases' started by pinch, Sep 7, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Whenever I use the Create Backup tool, I run into problems. If I generate a zip file and move it to my hard drive, I get the following error when I try to unzip it:

    "The Compressed (zipped) Folder is invalid or corrupted."

    If generate a .bak file and try to restore it with SMS, I get the following error:

    "Specified cast is not valid"

    I've gone through this routine before several times and it has worked, but I've run into these problems on and off. This time I can't seem to get it to work no matter how hard I try.
     
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    Pinch,
    When you download the file, it is more likely that the file is been corrupted. Please try running dbcc check db to make sure there is nothing wrong with your database. Then create the backup and try restoring that same backup (if static data only) onto the database, if possible.
     
  3. Hi junior,

    I really don't think there is anything wrong with my database and the FTP client I use to pull-down the .zip file is the one I've always used (CuteFTP), normally with success. I ran the command you suggested and it found no errors:

    At this point I'm reluctant to restore a backup that seems to be invalid and which I cannot prove is valid at this point. The database supporting my application is dynamic and is running fine without any problems. I haven't changed my application code in months and everything seems to be fully operational.

    I think I need someone to validate that the .zip and .bak files being generated by my tool are not corrupted on the server-side before I ftp them to my local workstation. I'm out of options at this point. Unless file corruption is common when ftping files there must be something else going on.
     
  4. I tried a new FTP editor and it seemed to work so it looks like the problem is with my ftp client.
     
  5. Bruce

    Bruce DiscountASP.NET Staff

    Make sure you use binary mode when you transfer this file.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page