How to recover a corrupted backup file?

(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
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
"Julio" <Julio@.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
>
|||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.
"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
>

How to recover a corrupted backup file?

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
Hi
Open a case with Microsoft Customer Support Services. They may be able to
help you.
http://support.microsoft.com
Regards
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Julio" <Julio@.discussions.microsoft.com> wrote in message
news:063ED50F-75B6-454E-A20D-7604F1C9415C@.microsoft.com...
>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
|||Done.
They do not recover damaged backup file. Just recover some existing
Databases with recoverable issues.
If someone has any suggestions, welcome.
Julio
"Michael Epprecht [MSFT]" wrote:

> Hi
> Open a case with Microsoft Customer Support Services. They may be able to
> help you.
> http://support.microsoft.com
> Regards
> --
> Mike
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Julio" <Julio@.discussions.microsoft.com> wrote in message
> news:063ED50F-75B6-454E-A20D-7604F1C9415C@.microsoft.com...
>
>

How to recover a corrupted backup file?

(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 lo
g
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 inputThe 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
"Julio" <Julio@.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
>|||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.
"Julio" wrote:

> (Posting to the right group)
> I backed up a database (SQL 2000) from EM but because some disk problems t
he
> 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
>