Dave,
I'm currently only working on documentations only. My databases didn't experience any of these errors, and i hope it never does. One of my production server crashed on Monday morning, apparently one of the controllers was acting up. When we were finally able to bring the servers back up i ran DBCC checkDB to see if there are any errors and apparently there wasn't. I had a meeting with my CIO and he wanted documentations of how to handle situations like this. I've been running the DBCC checkDB numerous times but never really came across or seen any errors. I just want to see if anyone have any experiences on it, and maybe i can learn and better prepare myself for a situation like this if it ever arises. Thank Everyone!
kaze

"Farnsworth, Dave" <[Email Address Removed] wrote: Get the database in single user mode and the rund DBCC CHECKDB with on of the following options;

{ REPAIR_ALLOW_DATA_LOSS
| REPAIR_FAST
| REPAIR_REBUILD }

Are you getting any dump files in your log directory?? If so you may want to give M$ a call.

Dave

-----Original Message-----
From: Kaze [mailto:[Email Address Removed] Wednesday, February 26, 2003 4:05 PM
To: LazyDBA.com Discussion
Subject: DBCC CheckDB



Hi Folks,

If i would to run DBCC CheckDB and comes back with allocation errors and consistency errors, what are the proper steps in solving these errors?

Thank You...

Kaze



---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more
MS Sql Server LazyDBA home page