Browse by Tags

All Tags » Consistency / dbcc (RSS)

It’s amazing what I didn’t know about dbcc !!

As part of a series of processes I manipulate ( cleanse )  a copy of production for use in a test/support environment, one of things which I do is switch to simple recovery and shrink the t-log. This process is automated overnight and is intended...
Posted by GrumpyOldDBA | with no comments

Why do I bother with RAID 10 ?

Before I post anything I just want to clarify what I mean by RAID 10 , this is sets of mirrored pairs that have been striped as against a RAID 0 which has been mirrored. I've just had a disk failure in the data array for one of my dev servers, it's...

dbcc checkdb - things you find

I was sorting out some corruption in a database , error 8966 for the curious, which was preventing a backup occuring which is always bad news. I just happened to run across the option ESTIMATEONLY which gives an idea of how much tempdb space is required...
Posted by GrumpyOldDBA | with no comments
Filed under: