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 |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2008-10-14 : 14:47:56
|
| Hi,I've corrupted DB.I want to bring few tables from corrupted to newely create database thru select * insert option.command shows error adn failed at bad page.Is there any way I can save data?please advice. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2008-10-14 : 15:15:07
|
| I've tested bcp's option also.The bcp is running ,running ..... and so,the moment it reached to corruped page,bcps failed.Looks to me fe tables are badly corrupted.Thanks for your quick response. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2008-10-14 : 16:14:41
|
| Yes, but I've backup of 9/21.I jumped into this issue after all these things get screwed up. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2008-10-14 : 16:31:54
|
| MS rep told only way to recover is select * insert but not fully data be recovered. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-10-17 : 10:38:37
|
| Can you post the output of the DBCC CheckDB with All_errormsgs, no_infomsgs? Not that you'll get a better or different answer than MS provided but you never know. You might've gotten a rep that is absolutely clueless - no, that could never happen, right?Terry |
|
|
|
salil.chaudhari
Starting Member
2 Posts |
Posted - 2008-10-24 : 01:06:40
|
| you can fix that problemand copy data using insert into or bcpRegardsSALIL |
|
|
|
|
|
|
UNABLE TO BRING DATA THRU SELECT * INSERT