Viewing 11 posts - 1 through 12 (of 12 total)
Hi there Jeff.
Very interesting story you have there. It wasn't that long, or my levels of interest went sky high when i started to read it.
The need to buy new...
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
December 29, 2012 at 10:22 am
Hi there Glenn.
I really enjoyed your post. Very concise and straighforward. Neverthless i think 64GB of RAM is bit overkill to a database that's only 16GB althgouh, like i said...
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
December 28, 2012 at 3:46 pm
Hi.
Thanks for posting. 🙂
I'm thinking something along these lines:
- AD+DC = 4GB
- SQL Server + simple messaging services= 10GB
- Retail (20 CAL) = 8GB
- RDS (5 CAL)= 4GB
- Production (1...
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
December 28, 2012 at 12:08 pm
whale
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
December 27, 2012 at 2:38 pm
Hi
I've never done it through Attach/Dettach, but by restoring from a fresh, perfectly good backup it went like a breeze.
But like the previous poster said, test it. Although dettaching...
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
November 30, 2012 at 12:35 pm
Solved.
RAID array had one black sheep.
Too bad that the card is so cheap it doesn't give any warning...
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
November 29, 2012 at 1:21 pm
GilaMonster (11/29/2012)
Machine getting frequently rebooted?
Not really, no.
Thanks for bringing that up, i'll now check if the write-caching gets enabled after each boot.
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
November 29, 2012 at 3:27 am
Just finished going through the procedure of running CHECKDB on another spin.
The first run required REPAIR_REBUILD. After that i ran CHECKDB 3 times in a row, and the results were...
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
November 29, 2012 at 3:13 am
GilaMonster (11/29/2012)
Ow, that's a waste of time. Ditch that plan entirely, go grab Ola's index maintenance script. Use that. Put checkDB (and your backups) in a separate plan
At this point...
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
November 29, 2012 at 1:29 am
GilaMonster (11/29/2012)
Are you doing index rebuilds right after the consistency checks?
These results were obtained running the command right from a query window.
I do have a scheduled maintenance plan (runs everyday...
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
November 29, 2012 at 12:42 am
GilaMonster (11/28/2012)
No, it won't be the OS drive if the database files aren't on it.Errors please.
Hi Gail, thanks for the quick reply.
On this run of CHECKDB WITH ALL_ERRORMSGS i got...
____________________________________________________________
If you can't do things right at the first time, don't try skydiving. I won't.
November 29, 2012 at 12:23 am
Viewing 11 posts - 1 through 12 (of 12 total)