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 |
|
sankar_libra
Starting Member
1 Post |
 Posted - 2008-07-31 : 03:02:45
|
| CHECKDB found 0 allocation errors and 153 consistency errors in database 'test'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (test).can we repair without data loss? |
|
|
surya_rakanta
Starting Member
19 Posts |
Posted - 2008-07-31 : 03:21:18
|
| What is the error log says about this ?Do you try to detach, then re-attach the database ?RgdsEka S.God didn't do this, Anna, WE did.— Robert Neville in I am Legend. |
 |
|
|
surya_rakanta
Starting Member
19 Posts |
Posted - 2008-07-31 : 05:11:00
|
| can we repair without data loss?--------Depends on the extent of error.God didn't do this, Anna, WE did.— Robert Neville in I am Legend. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-31 : 23:11:47
|
| >> Do you try to detach, then re-attach the database ?I'll not take that risk, you may unable to reattach the db. |
|
|
|
surya_rakanta
Starting Member
19 Posts |
Posted - 2008-08-01 : 06:45:20
|
| I'll not take that risk, you may unable to reattach the db.-----OK, what's the current database status ? If it's in suspect mode or emergence mode, then it is the same as having the database not attached isn't it ? :) At the least, based on my experience, I can not view the tables, data, etc in SQL EM when in suspect or emergency mode.If it can't be attach, then pay attention to the error (in error log) and resolve it one by one until you have fully functional database that subsequently can be copied to healthy one.RgdsEka S.Here is a thing about the future : every time you look at it, it changes. Because you look at it, that changes everything else.-Frank Cadillac in NEXT |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-02 : 14:21:25
|
| If db is in suspect mode or emergence mode, you still can reset status and get some needed info. Once you detach it, you'll unable to get it back for sure. Why don't pay attention to errors while the db is still present? |
|
|
|
|
|
|
|
|
Sql DB corrupt