1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL backup corrupted or unreadable

Discussion in 'Windows XP' started by maitakeboy, Jul 9, 2010.

  1. maitakeboy

    maitakeboy Flightless Bird

    I did a backup of a 36GB SQL database to a USB hard drive, which completed
    successfully. When I went to copy that backup to my archive server, at around
    40% it errored aaying the file was unreadable or corrupted. Of course, I had
    already deleted the database since I needed room on my server and thought I
    had a good backup.
    I've tried everything I know, including trying to undelete the databse files
    from the server, which found nothing and running chkdsk on the USB drive. Of
    course, when I did that, it showed the file as having 0 KB!
    So am I hosed or what? is there anything else anyone can suggest to try and
    recover this file from my USB?
     
  2. Greg Russell

    Greg Russell Flightless Bird

    In news:7778B764-A47A-4AC2-82FB-B260E2D4B5D5@microsoft.com,
    maitakeboy <maitakeboy@discussions.microsoft.com> typed:
    > I did a backup of a 36GB SQL database to a USB hard drive, which
    > completed successfully. When I went to copy that backup to my archive
    > server, at around 40% it errored aaying the file was unreadable or
    > corrupted. Of course, I had already deleted the database since I
    > needed room on my server and thought I had a good backup.
    > I've tried everything I know, including trying to undelete the
    > databse files from the server, which found nothing and running chkdsk
    > on the USB drive. Of course, when I did that, it showed the file as
    > having 0 KB!
    > So am I hosed or what? is there anything else anyone can suggest to
    > try and recover this file from my USB?


    At this time, after you deleted the original database, you are indeed
    "hosed". Is your USB drive formatted as FAT32? If so then the maximum file
    size is only 4GB.

    You may wish to apply as a poster child for what not to do when making
    backups. So very many people make backups and never test the integrity of
    them before making the fateful decision to delete the originals, just as you
    did.
     
  3. Allan

    Allan Flightless Bird

    "Greg Russell" <grussell@example.con> wrote in message
    news:89pan6FuvsU1@mid.individual.net...
    > In news:7778B764-A47A-4AC2-82FB-B260E2D4B5D5@microsoft.com,
    > maitakeboy <maitakeboy@discussions.microsoft.com> typed:
    >> I did a backup of a 36GB SQL database to a USB hard drive, which
    >> completed successfully. When I went to copy that backup to my archive
    >> server, at around 40% it errored aaying the file was unreadable or
    >> corrupted. Of course, I had already deleted the database since I
    >> needed room on my server and thought I had a good backup.
    >> I've tried everything I know, including trying to undelete the
    >> databse files from the server, which found nothing and running chkdsk
    >> on the USB drive. Of course, when I did that, it showed the file as
    >> having 0 KB!
    >> So am I hosed or what? is there anything else anyone can suggest to
    >> try and recover this file from my USB?

    >
    > At this time, after you deleted the original database, you are indeed
    > "hosed". Is your USB drive formatted as FAT32? If so then the maximum file
    > size is only 4GB.

    Wait a second, he may have used backup software such as drive imaging that
    breaks the image into small pieces. I use Clonezilla to back up partitions.
    It does sound though like he needs more than one USB hard drive or other
    media to ensure his data integrity.
     
  4. Greg Russell

    Greg Russell Flightless Bird

    In news:#26$iyCJLHA.4496@TK2MSFTNGP02.phx.gbl,
    Allan <mu8ja0i@earthlink.net> typed:

    >>> So am I hosed or what? is there anything else anyone can suggest to
    >>> try and recover this file from my USB?

    >>
    >> At this time, after you deleted the original database, you are indeed
    >> "hosed". Is your USB drive formatted as FAT32? If so then the
    >> maximum file size is only 4GB.

    >
    > Wait a second, he may have used backup software such as drive imaging
    > that breaks the image into small pieces.


    You should've spent at least a second reading the OP before replying.
     

Share This Page