Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2 Expand / Collapse
Author
Message
Posted Tuesday, September 13, 2011 6:25 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:18 AM
Points: 832, Visits: 1,485
crazy4sql (9/13/2011)

Denali's coming out in a few months if you can wait it out


As much I am aware about denali, you cant upgrade sql 2000 database to denali directly. You need to upgrade it to either 2005 or 2008 and then denali.

Microsoft gives the explanation for this:- We expect your environment should be upgraded to at least 2005 by now.


ya, i would be more conservative now, 05 is good enough for me
Post #1174073
Posted Tuesday, September 13, 2011 6:28 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:18 AM
Points: 832, Visits: 1,485
Ninja's_RGR'us (9/13/2011)
halifaxdal (9/13/2011)


Denali's coming out in a few months if you can wait it out


That would be probably next year!

Those guys are chasing me and expecting me to make it working in one day!


Time for a meeting about the sla, rpo & rto and buying more disk space and allotting the time you need to setup DR all over the place.


absolutely!

BTW: for db like this size (800G and grew to this from 3G in 4 years), what's everyone's advise in terms of admin and performance optimization? I would like to hear from this. Thanks.
Post #1174074
Posted Tuesday, September 13, 2011 6:32 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, November 27, 2014 4:23 AM
Points: 20,584, Visits: 9,624
Get Gail in for a consult. Can't be done over forums.
Post #1174079
Posted Tuesday, September 13, 2011 6:46 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:18 AM
Points: 832, Visits: 1,485
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.
Post #1174092
Posted Tuesday, September 13, 2011 6:51 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, November 27, 2014 4:23 AM
Points: 20,584, Visits: 9,624
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.


Then wait 400 years untill mankind lives without money and all will be good.

In the meantime, learn this stuff or ask more precise questions .
Post #1174097
Posted Tuesday, September 13, 2011 7:55 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:18 AM
Points: 832, Visits: 1,485
Then wait 400 years untill mankind lives without money and all will be good.


I would really very much like to have money to spend, I just don't see the chance it will get approved by a top 5 bank

I personally feel I owe you guys and will surely invite you for a traditional Chinese brunch if I had the opportunity. That's very yummy......

In the meantime, learn this stuff or ask more precise questions .

Sure


Post #1174173
Posted Tuesday, September 13, 2011 7:56 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, November 27, 2014 4:23 AM
Points: 20,584, Visits: 9,624
halifaxdal (9/13/2011)
Then wait 400 years untill mankind lives without money and all will be good.


I would really very much like to have money to spend, I just don't see the chance it will get approved by a top 5 bank

I personally feel I owe you guys and will surely invite you for a traditional Chinese brunch if I had the opportunity. That's very yummy......

In the meantime, learn this stuff or ask more precise questions .

Sure




The meal is nice. That's the airfare that's going to kill ya .
Post #1174175
Posted Tuesday, September 13, 2011 7:58 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:18 AM
Points: 832, Visits: 1,485
OK, back to the topic, it would be greatly appreciated if you can watch this more like a realtime, I will be having a conf with the original db's tech owner at 10am, I will post update from him here
Post #1174177
Posted Tuesday, September 13, 2011 7:59 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Thursday, November 27, 2014 4:23 AM
Points: 20,584, Visits: 9,624
halifaxdal (9/13/2011)
OK, back to the topic, it would be greatly appreciated if you can watch this more like a realtime, I will be having a conf with the original db's tech owner at 10am, I will post update from him here


What do you mean realtime?


Post #1174182
Posted Tuesday, September 13, 2011 8:06 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:18 AM
Points: 832, Visits: 1,485
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
Post #1174191
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse