Home > Archive > MS SQL Server Tools > October 2006 > How to recover a corrupted backup file?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author How to recover a corrupted backup file?
Julio

2006-10-24, 6:45 pm

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
Michael Epprecht [MSFT]

2006-10-24, 6:45 pm

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@microso
ft.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



Julio

2006-10-24, 6:45 pm

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@microso
ft.com...
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com