SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2


DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2

Author
Message
Ninja's_RGR'us
Ninja's_RGR'us
SSC Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70323 Visits: 9671
halifaxdal (9/13/2011)
A backup room is being seeked and hopefully we find it so we don't have to do the fix on the real prod server


Stupid-ish question. Any other db on that server?

If not you could always backup all system dbs and try doing the work there (assuming getting that back up 24 hours earlier is a big plus and there's no downside if you kill the server)
GilaMonster
GilaMonster
SSC Guru
SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)

Group: General Forum Members
Points: 235330 Visits: 46376
halifaxdal (9/13/2011)
Ninja's_RGR'us (9/13/2011)
[quote]halifaxdal (9/13/2011)
[quote]GilaMonster (9/13/2011)
Run SP_configure and set allow updates to 1. Update sysdatabases for that database and set the status to 32767.

Then see if you can access the DB and run checkdb. Not repair, just with the no_infomsgs and all_errormsgs options.


can you elaborate? i thought before SP_configure i have to be in that db, and it won't let me in that db. meaning the following won't work? or I just need to use in master?

use sels
go
sp_configure 'Allow updates',1
go


You can run that anywhere, it's a server-wide setting.

What do you mean 'won't let you'? It's going to require sysadmin permissions, as will just about everything else.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


GilaMonster
GilaMonster
SSC Guru
SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)

Group: General Forum Members
Points: 235330 Visits: 46376
halifaxdal (9/13/2011)
Ninja's_RGR'us (9/13/2011)
Get Gail in for a consult. Can't be done over forums.


I would love to, but if that costs any expense, then I personally can't make it.;-)


Absolutely, I'd recommend getting someone in to look at it. No one was suggesting you pay it (my rates aren't targeted at individuals), your company should get someone in and pay for it.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Ninja's_RGR'us
Ninja's_RGR'us
SSC Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70323 Visits: 9671
GilaMonster (9/13/2011)
halifaxdal (9/13/2011)
Ninja's_RGR'us (9/13/2011)
Get Gail in for a consult. Can't be done over forums.


I would love to, but if that costs any expense, then I personally can't make it.;-)


Absolutely, I'd recommend getting someone in to look at it. No one was suggesting you pay it (my rates aren't targeted at individuals), your company should get someone in and pay for it.



And Gail has worked / consulted with Banks before so I doubt it would be a very hard sale to make to your bosses.


And there's clearly something very wrong in the system (2 major corruption events in a couple weeks), you're over your head and you need help. She's proven she can provide it to you.

Not much left to talk about at this point ;-)
GilaMonster
GilaMonster
SSC Guru
SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)

Group: General Forum Members
Points: 235330 Visits: 46376
halifaxdal (9/13/2011)
A backup room is being seeked and hopefully we find it so we don't have to do the fix on the real prod server


If you don't have another server, then work on that server, just be aware if there are any other DBs you could impact their performance at the least. If you make a mistake, you could break those DBs.

As for realtime assistance, that I charge for. I'll be around for the next few hours, but I have a lot of paying work and studying that I still have to do today.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


halifaxdal
halifaxdal
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4804 Visits: 1768
GilaMonster (9/13/2011)
halifaxdal (9/13/2011)
Ninja's_RGR'us (9/13/2011)
Get Gail in for a consult. Can't be done over forums.


I would love to, but if that costs any expense, then I personally can't make it.;-)


Absolutely, I'd recommend getting someone in to look at it. No one was suggesting you pay it (my rates aren't targeted at individuals), your company should get someone in and pay for it.

Understood that, last time when I tried to sell the idea of buying Steller SQL Recovery Tool, I was blamed by my boss which really hurts me.
Ninja's_RGR'us
Ninja's_RGR'us
SSC Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70323 Visits: 9671
halifaxdal (9/13/2011)
GilaMonster (9/13/2011)
halifaxdal (9/13/2011)
Ninja's_RGR'us (9/13/2011)
Get Gail in for a consult. Can't be done over forums.


I would love to, but if that costs any expense, then I personally can't make it.;-)


Absolutely, I'd recommend getting someone in to look at it. No one was suggesting you pay it (my rates aren't targeted at individuals), your company should get someone in and pay for it.

Understood that, last time when I tried to sell the idea of buying Steller SQL Recovery Tool, I was blamed by my boss which really hurts me.


Blamed?

I'd go over his head or straight to HR with this. There's more than just DR wrong with this... let's call it department at this point.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search