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 problem
and copy data using insert into or bcp
Regards
SALIL |
|
|
|
|
|
|
UNABLE TO BRING DATA THRU SELECT * INSERT