|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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 -- Show quoteMike This posting is provided "AS IS" with no warranties, and confers no rights. "Julio" <Ju***@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 Show quote "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" <Ju***@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 > > > |
|||||||||||||||||||||||