Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DeepBlueSea
Starting Member
5 Posts |
 Posted - 2005-08-19 : 13:44:49
|
| Hi,Some of the data files on our database got corrupted. Is there any tool to get just the data out of the data files and dump somewhere. We can manually rebuild the database using the schema scripts and loading the data. Appreciate any help. Any suggestions are welcome too.Thanks. |
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2005-08-19 : 15:02:18
|
quote:
Originally posted by DeepBlueSea
Hi,Some of the data files on our database got corrupted. Is there any tool to get just the data out of the data files and dump somewhere. We can manually rebuild the database using the schema scripts and loading the data. Appreciate any help. Any suggestions are welcome too.Thanks.
Can you describe what you mean by 'corrupt'? Do you mean that you can't access the files at all? Have you run DBCC CHECKDB? Can you please post the output of that command if you have?----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
DeepBlueSea
Starting Member
5 Posts |
Posted - 2005-08-19 : 15:53:23
|
| The data files got messed up while changing the disks. We are not able to execute DBCC CHECKDB command. For now, MSSQLRecovery tool seems to be best way to go. Is there any other tool, which can recover the data from the corrupt files?Thanks. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-19 : 22:27:12
|
| If you try to BCP out each table, one by one, can you successfully export most/any of them?Kristen |
|
|
|
DeepBlueSea
Starting Member
5 Posts |
Posted - 2005-08-26 : 19:09:27
|
| Thanks all for your help. We had to use "Recovery for SQL Server" from www.officerecovery.com. It was quite useful and we were able to retrieve all the data, which was not corrupt. |
|
|
|
|
|
|
Tools to repair corrupt data file