<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
Data Corruption
»
DB corrupted with event 17052 and Error: 823,...
37 posts, Page 4 of 4
««
«
1
2
3
4
DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2
Rate Topic
Display Mode
Topic Options
Author
Message
Ninja's_RGR'us
Ninja's_RGR'us
Posted Tuesday, September 13, 2011 8:09 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 21,357,
Visits: 9,535
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)
Post #1174195
GilaMonster
GilaMonster
Posted Tuesday, September 13, 2011 8:16 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 6:25 AM
Points: 37,679,
Visits: 29,934
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 2008, MVP
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
Post #1174205
GilaMonster
GilaMonster
Posted Tuesday, September 13, 2011 8:17 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 6:25 AM
Points: 37,679,
Visits: 29,934
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 2008, MVP
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
Post #1174206
Ninja's_RGR'us
Ninja's_RGR'us
Posted Tuesday, September 13, 2011 8:19 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 21,357,
Visits: 9,535
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
Post #1174209
GilaMonster
GilaMonster
Posted Tuesday, September 13, 2011 8:19 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 6:25 AM
Points: 37,679,
Visits: 29,934
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 2008, MVP
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
Post #1174210
halifaxdal
halifaxdal
Posted Tuesday, September 13, 2011 8:24 AM
Say Hey Kid
Group: General Forum Members
Last Login: Friday, May 10, 2013 8:49 AM
Points: 661,
Visits: 1,187
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.
Post #1174215
Ninja's_RGR'us
Ninja's_RGR'us
Posted Tuesday, September 13, 2011 8:26 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 21,357,
Visits: 9,535
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.
Post #1174218
« Prev Topic
|
Next Topic »
37 posts, Page 4 of 4
««
«
1
2
3
4
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
