February 16, 2010 at 12:10 pm
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.
February 16, 2010 at 1:01 pm
NEI, Not Enough Information.
Have you checked the SQL Server logs for errors? If so, what errors were reported?
February 16, 2010 at 1:17 pm
Extract all the objects using SSIS package, to be in safe side.
EnjoY!
February 16, 2010 at 1:25 pm
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.EnjoY!
huh?? Sounds like a developer trying to do a DBA's job.
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 1:28 pm
I second Lynn's motion.
Please provide more information. Error messages are critical pieces of information to share.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 16, 2010 at 1:36 pm
sqldba551 (2/16/2010)
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
Right now, immediately, stop everything!
First thing to do when a database is suspect is find why SQL marked it suspect. Look in the SQL error log, there will be entries in there. Find them, post them here.
Do not attempt any repairs without checking why the DB is suspect in the first place.
Do you have good backups of this database?
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 1:38 pm
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.
Do you have the vaguest idea what you're talking about here?
A suspect database is not online (that's why it's suspect) and hence the objects aren't accessible to script out.
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 1:46 pm
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.Do you have the vaguest idea what you're talking about here?
A suspect database is not online (that's why it's suspect) and hence the objects aren't accessible to script out.
lol
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 16, 2010 at 1:50 pm
Bru Medishetty (2/16/2010)
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.Do you have the vaguest idea what you're talking about here?
A suspect database is not online (that's why it's suspect) and hence the objects aren't accessible to script out.
lol
Well if you change Database to emergency mode, you should be able to extract data, i have done this before.
EnjoY!
February 16, 2010 at 1:53 pm
GT-897544 (2/16/2010)
Bru Medishetty (2/16/2010)
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.Do you have the vaguest idea what you're talking about here?
A suspect database is not online (that's why it's suspect) and hence the objects aren't accessible to script out.
lol
Well if you change Database to emergency mode, you should be able to extract data, i have done this before.
Yes, if you can set it to Emergency, which isn't always possible and if there is no backup and if there is no other solution. It's far from the immediate, first recommended solution.
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 1:59 pm
Alvin Ramard (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.EnjoY!
huh?? Sounds like a developer trying to do a DBA's job.
Please try to change your DB to Emergency mode and see if you can extract data or not using import export wizard.
EnjoY!
February 16, 2010 at 2:04 pm
GT-897544 (2/16/2010)
Please try to change your DB to Emergency mode and see if you can extract data or not using import export wizard.
No! Extract data is NOT the first choice in a suspect DB problem. Switching to Emergency mode may or may not be required, depending on what cause the problem, why SQL has marked the DB suspect.
The first thing with a suspect DB is to find out why SQL marked it suspect. There will be errors in the error log.
If those errors can't be rectified, the best option is to restore from backup
It's only if there isn't a backup that one should attempt an Emergency Mode repair
It's only if Emergency mode repair fails that extract of objects is necessary.
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:05 pm
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
Bru Medishetty (2/16/2010)
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.Do you have the vaguest idea what you're talking about here?
A suspect database is not online (that's why it's suspect) and hence the objects aren't accessible to script out.
lol
Well if you change Database to emergency mode, you should be able to extract data, i have done this before.
Yes, if you can set it to Emergency, which isn't always possible and if there is no backup and if there is no other solution. It's far from the immediate, first recommended solution.
I agree that's my point Gail, I have done both changing database to emergency mode and extracting data. I had also restore database from latest backups if necessay. Bru, did you ever see Database in supsect mode as a DBA, if so what did you do to fix it?:hehe:
EnjoY!
February 16, 2010 at 2:08 pm
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..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 16, 2010 at 2:09 pm
GT-897544 (2/16/2010)
Alvin Ramard (2/16/2010)
GT-897544 (2/16/2010)
Extract all the objects using SSIS package, to be in safe side.EnjoY!
huh?? Sounds like a developer trying to do a DBA's job.
Please try to change your DB to Emergency mode and see if you can extract data or not using import export wizard.
EnjoY!
If I have the choice of listening to either you or Gila Monster my choice will be the latter.
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]
Viewing 15 posts - 1 through 15 (of 62 total)
You must be logged in to reply to this topic. Login to reply