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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-05-22 : 12:25:12
|
| Hi GurusSorry to rake up this issue again.we repaired this master by dbcc checkdb and now it is fine.What is this going on?do i have the chance that this willstillgodown as mentioned by paul .RegardsNitin |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-22 : 12:54:26
|
| Did you have to use one of the WITH-DATA-LOSS options?Because if so do you know what data was lost and what effect that's likely to have?Kristen |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-22 : 13:35:36
|
| Hey Kirsteni am nt concerned about dataloss at the moment.Just wanted to know can this come up again?regardsnitin |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-22 : 13:57:04
|
| Well I think you should be concerned about data loss in the MASTER database. It may have wiped out something critical which will then mean you have no way of knowing why strange things are happening from now onwards!Kristen |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-22 : 15:03:48
|
| Yeah i checked the logs.it was with allow data lossthanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-22 : 15:08:41
|
| If the problem is due to hardware (which Paul Randall already told you he is 99% certain that it is), then your database is just going to become corrupt again. Paul works for Microsoft in the SQL Server team, so you should take his advice.Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-05-22 : 16:30:08
|
| Yes TaraI have fwd the request to my network team.Letz see..Thanks for helping tara and kirstenRegardsNitin |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-23 : 01:52:42
|
| "Thanks for helping tara and kirsten"Sorry to be blunt:Are you working on the assumption that all the databases on your server are hosed?Because if not then I don't think I have helped ...Kristen |
|
|
|
|
|
|
Error in master db