How to recover a corrupted backup file?

19 Oct 2006 11:04 PM

Julio

(Posting to the right group)

I backed up a database (SQL 2000) from EM but because some disk problems the
file became corrupted. Aparently part of the problem was the transaction log
did was not truncated before (it is twice the size of the data)

Is there any tool (freebie) that allows me to recover data from the
corrupted dump file? I can open it with notepad and tested it with demo
MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
there is a lot of work in there.

Thank you for any input

19 Oct 2006 11:39 PM

Sylvain Lafontaine

The fact that the transaction log is twice the size of the data doesn't
necessary mean that it is corrupted. This is normal if you are using the
Full Recovery Mode and that you never backuped the log file. For shrinking
the log file, you must first back-it up (and not just only backup the data
file).

SQL Log Rescue from Red-Gate is a good tool to recover data from the log
file.

For the data file, I don't know.

It's not a good idea to make a backup only on the hard drive, without any
external copy.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

Show quoteHide quote

"Julio" <Ju***@discussions.microsoft.com> wrote in message
news:BD52AE00-E4F2-496A-BE41-855994DFBBA5@microsoft.com...
> (Posting to the right group)
>
> I backed up a database (SQL 2000) from EM but because some disk problems
> the
> file became corrupted. Aparently part of the problem was the transaction
> log
> did was not truncated before (it is twice the size of the data)
>
> Is there any tool (freebie) that allows me to recover data from the
> corrupted dump file? I can open it with notepad and tested it with demo
> MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
> there is a lot of work in there.
>
> Thank you for any input
>

19 Oct 2006 11:49 PM

Julio

Thank you for the info.

The issue is that database became corrupted upon restore (I know, all was
done wrong), but I see data is still there on the dump file. I was looking
for a tool able to check the dump file and try to fix it (I'm working on a
copy of it) or some trick to force it to restore and repair it.

Show quoteHide quote

"Julio" wrote:

> (Posting to the right group)
>
> I backed up a database (SQL 2000) from EM but because some disk problems the
> file became corrupted. Aparently part of the problem was the transaction log
> did was not truncated before (it is twice the size of the data)
>
> Is there any tool (freebie) that allows me to recover data from the
> corrupted dump file? I can open it with notepad and tested it with demo
> MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
> there is a lot of work in there.
>
> Thank you for any input
>

Thread options