February 16, 2010 at 2:12 pm
sqldba551 (2/16/2010)
Hi,As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT FIRST IN EMERGENCY MODE,AND LATER ON TO ONLINE
BUt it is going to emergency mode,when i am trying to set to single user it is showing error.
Pls help me how to come out of this issue.
regards,
Namasivah.
Try this first, if this doesn't follow Gails suggestion.
At least that is what I would do. And by dbcc I mean with “DBCC CHECKTABLE” REPAIR_REBUILD. If that did not complete successful after two or three times I would then use “REPAIR_ALLOW_DATA_LOSS” option.
February 16, 2010 at 2:16 pm
GT-897544 (2/16/2010)
sqldba551 (2/16/2010)
Hi,As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT FIRST IN EMERGENCY MODE,AND LATER ON TO ONLINE
BUt it is going to emergency mode,when i am trying to set to single user it is showing error.
Pls help me how to come out of this issue.
regards,
Namasivah.
Try this first, if this doesn't follow Gails suggestion.
At least that is what I would do. And by dbcc I mean with “DBCC CHECKTABLE” REPAIR_REBUILD. If that did not complete successful after two or three times I would then use “REPAIR_ALLOW_DATA_LOSS” option.
Actually, your suggestion is no where near the top of my list. First is to determine why the databases were in suspect mode first. Check the SQL Server logs for error messages, check the application and system logs to see what else may have happened that would have an affect on my databases.
Once that is done, then start to determine a proper course of action.
And DBCC with REPAIR_ALLOW_DATA_LOSS is an absolute last resort.
February 16, 2010 at 2:18 pm
GT-897544 (2/16/2010)
sqldba551 (2/16/2010)
Hi,As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT FIRST IN EMERGENCY MODE,AND LATER ON TO ONLINE
BUt it is going to emergency mode,when i am trying to set to single user it is showing error.
Pls help me how to come out of this issue.
regards,
Namasivah.
Try this first, if this doesn't follow Gails suggestion.
At least that is what I would do. And by dbcc I mean with “DBCC CHECKTABLE” REPAIR_REBUILD. If that did not complete successful after two or three times I would then use “REPAIR_ALLOW_DATA_LOSS” option.
Step away from the database with your hands in plain view.
Seriously, if that's your first suggestion for handling a suspect database, you need to stay away from databases. Some other DBA is going to have to come along after you get fired and try to fix the problems you are causing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 16, 2010 at 2:19 pm
Bru Medishetty (2/16/2010)
GT-897544 (2/16/2010)
Bru, did you ever see Database in supsect mode as a DBA, if so what did you do to fix it?:hehe:EnjoY!
I liked Gail's witty reply and was not to embarrass you by any means..
I don't care about witty reply because, some members did not have an idea what they were talking about, Come on Bru take it easy 😀
EnjoY!
February 16, 2010 at 2:23 pm
GT-897544 (2/16/2010)
Bru Medishetty (2/16/2010)
GT-897544 (2/16/2010)
Bru, did you ever see Database in supsect mode as a DBA, if so what did you do to fix it?:hehe:EnjoY!
I liked Gail's witty reply and was not to embarrass you by any means..
I don't care about witty reply because, some members did not have an idea what they were talking about, Come on Bru take it easy 😀
EnjoY!
If you are saying Gail doesn't know what she is talking about, I'd watch your backside. She knows more about database corruption then many of us, and I have been using SQL Server since version 6.5.
February 16, 2010 at 2:24 pm
sqldba551 (2/16/2010)
Hi,As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT FIRST IN EMERGENCY MODE,AND LATER ON TO ONLINE
BUt it is going to emergency mode,when i am trying to set to single user it is showing error.
Pls help me how to come out of this issue.
regards,
Namasivah.
Check these steps by Paul Randal.
EnjoY!
February 16, 2010 at 2:26 pm
GT-897544 (2/16/2010)
And by dbcc I mean with “DBCC CHECKTABLE” REPAIR_REBUILD. If that did not complete successful after two or three times I would then use “REPAIR_ALLOW_DATA_LOSS” option.
Oh for crying out loud!
It is impossible to recommend a repair level for corruption without seeing the full and complete output of CheckDB WITHOUT a repair level.
If repair rebuild doesn't do the job the first time, it won't do it the second, third, forth or 500th time. If a CheckDB returns that the minimum leevl to repair is something other than REPAIR_REBUILD, it is senseless and useless to suggest REPAIR_REBUILD
I should also mention that in Emergency Mode, the only repair level that's allowed is REPAIR_ALLOW_DATA_LOSS. That's what I referred to earlier when I mentioned "Emergency mode repair" It's almost the last resort and should only be done if there's no database backup to restore from.
It is not the first thing that should be tried with a suspect or damaged database. It's the last thing and if it fails, then it's data extraction time.
For corruption, this may be worth a read. http://www.sqlservercentral.com/articles/65804/ Unfortunately there isn't a good article on suspect databases yet, though I recommend Paul Randal's blog.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2010 at 2:28 pm
Lynn Pettis (2/16/2010)
GT-897544 (2/16/2010)
Bru Medishetty (2/16/2010)
GT-897544 (2/16/2010)
Bru, did you ever see Database in supsect mode as a DBA, if so what did you do to fix it?:hehe:EnjoY!
I liked Gail's witty reply and was not to embarrass you by any means..
I don't care about witty reply because, some members did not have an idea what they were talking about, Come on Bru take it easy 😀
EnjoY!
If you are saying Gail doesn't know what she is talking about, I'd watch your backside. She knows more about database corruption then many of us, and I have been using SQL Server since version 6.5.
I didn't say that about Gail :hehe:
February 16, 2010 at 2:29 pm
GT-897544 (2/16/2010)
Lynn Pettis (2/16/2010)
GT-897544 (2/16/2010)
Bru Medishetty (2/16/2010)
GT-897544 (2/16/2010)
Bru, did you ever see Database in supsect mode as a DBA, if so what did you do to fix it?:hehe:EnjoY!
I liked Gail's witty reply and was not to embarrass you by any means..
I don't care about witty reply because, some members did not have an idea what they were talking about, Come on Bru take it easy 😀
EnjoY!
If you are saying Gail doesn't know what she is talking about, I'd watch your backside. She knows more about database corruption then many of us, and I have been using SQL Server since version 6.5.
I didn't say that about Gail :hehe:
It's all in how you read your post. Perspective. I've learned a lot about perspective on the pitch as a ref.
February 16, 2010 at 2:30 pm
GT-897544 (2/16/2010)
sqldba551 (2/16/2010)
Hi,As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT FIRST IN EMERGENCY MODE,AND LATER ON TO ONLINE
BUt it is going to emergency mode,when i am trying to set to single user it is showing error.
Pls help me how to come out of this issue.
regards,
Namasivah.
Check these steps by Paul Randal.
EnjoY!
Read what's at the top of the page for the link you posted:
CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 16, 2010 at 2:35 pm
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
And by dbcc I mean with “DBCC CHECKTABLE” REPAIR_REBUILD. If that did not complete successful after two or three times I would then use “REPAIR_ALLOW_DATA_LOSS” option.Oh for crying out loud!
It is impossible to recommend a repair level for corruption without seeing the full and complete output of CheckDB WITHOUT a repair level.
If repair rebuild doesn't do the job the first time, it won't do it the second, third, forth or 500th time. If a CheckDB returns that the minimum leevl to repair is something other than REPAIR_REBUILD, it is senseless and useless to suggest REPAIR_REBUILD
I should also mention that in Emergency Mode, the only repair level that's allowed is REPAIR_ALLOW_DATA_LOSS. That's what I referred to earlier when I mentioned "Emergency mode repair" It's almost the last resort and should only be done if there's no database backup to restore from.
It is not the first thing that should be tried with a suspect or damaged database. It's the last thing and if it fails, then it's data extraction time.
For corruption, this may be worth a read. http://www.sqlservercentral.com/articles/65804/ Unfortunately there isn't a good article on suspect databases yet, though I recommend Paul Randal's blog.
Alright Gail, What you do in this situation? Don't you take action first and bring database online first rather than trying to figure what error messages say? Can't we restore if we have latest backup first and bring the database online and do whatever you want to later?
EnjoY!
February 16, 2010 at 2:37 pm
The first step for any problem is to find out what is the problem.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
February 16, 2010 at 2:40 pm
Alvin Ramard (2/16/2010)
GT-897544 (2/16/2010)
sqldba551 (2/16/2010)
Hi,As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT FIRST IN EMERGENCY MODE,AND LATER ON TO ONLINE
BUt it is going to emergency mode,when i am trying to set to single user it is showing error.
Pls help me how to come out of this issue.
regards,
Namasivah.
Check these steps by Paul Randal.
EnjoY!
Read what's at the top of the page for the link you posted:
CHECKDB From Every Angle: EMERGENCY mode repair - the very, very last resort
Yes, i did read that.
BUt it is going to emergency mode, when i am trying to set to single user it is showing error.
Namasivah had already set it to Emergency mode.
EnjoY!
February 16, 2010 at 2:40 pm
I have to agree with Alvin, the first step is to determine what the problem is before just jumping in and doing something that may cause more problems.
February 16, 2010 at 2:42 pm
This whole post makes me laugh..
Basic Troubleshooting 101:
1. Find out WHY you have the problem in the first place
It is clear that GT-897544 has very little real world experience, and a data extract is right near the bottom of the list for solving this problem.
The problem could be as simple as a disk is offline, but nobody will know until the cause has been looked at.
Research FIRST, then ACT. How can anyone who what is the right course of action until they have some idea of the problem.
To the original poster, look at the error logs, they will almost certainly tell you exactly why the database is suspect. Once have those messages you can post them and we can help you.
CEWII
Viewing 15 posts - 16 through 30 (of 62 total)
You must be logged in to reply to this topic. Login to reply