SQL Server, PASS, and other data mishaps
SQL/Windows Clustering Stupidity
When is high availibility not?
When its any version of SQL running on a clustered Windows 2003 Server or sql 2005 running on clustered Windows 2008 Server. Seems that while you can dynamically add a disk and use it in SQL when your running a standalone server, if your running in a “highly availiable” cluster configuration you have to take SQL offline to add the disk as a dependency in order to be able to use it within SQL. Here’s the proof right from SQL books online.
Im sure there was a good reason to require this at the time but clearly this wasnt thought out in the grand scheme of taking 0 downtime. Anytime a single server has a more highly availiable architecture than your system that is designed for high availibility –>youre doing it wrong, Sorry someone had to say it
| Print article | This entry was posted by Allen Kinsel on February 18, 2010 at 10:04 am, and is filed under Rants, SQL Server. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
No comments yet.
No trackbacks yet.
Invitation for T-SQL Tuesday #19 – Disasters & Recovery
about 8 months ago - 37 comments
Disasters
Its the first week of June and for those of us living along the Gulf and Atlantic coasts of the US, that brings the beginning of hurricane season. It also means its time for this months installment of T-SQL Tuesday.
This Months Topic
Disaster Recovery. This topic is very near and dear to me based on the fact that
99 problems and the disk aint one
about 9 months ago - No comments
Its Meme Monday again and this time Tom has picked an interesting topic.
How many problems do we all see in our shops that arent related to disks? Since disk related issues would normally be my #1-10 I guess Ill have to start at #11
.
11. ESX misconfigurations
12. Old DBMS Version requirements from vendors
13. Bad DB design
14.
How deep can you dive?
about 10 months ago - 10 comments
After last years Summit we launched a feedback site http://feedback.sqlpass.org in hopes of gathering all of the feedback about the event in one place. The number one thing people have asked for on that site is for there to be a track of sessions in the 400-500 level range. The problems with the community desire
The 3 most important words for a DBA
about 11 months ago - 2 comments
Occasionally I’m asked what the most important thing for a DBA to know is. It seems some people want to know what 1 thing to focus on in order to be successful long term as a DBA. I’ve pondered this question for quite a long time and I’ve given various answers over the years.
Reality intervenes
Ive
Database Automagic
about 12 months ago - 5 comments
This months TSQL Tuesday is hosted by a good friend Pat right over at SQL Asylum
For this months entry I decided to keep it short and sweet, following in my Bits N Bytes theme.
The Meta Script
In the true sense of the word automation, this really doesn’t fit but, in the terms of quickly getting something
A tall tale of SQL database corruption
about 1 year ago - 4 comments
This corruption story begins like many. Somebody in a server room far far away decided to make a change to a VMware guest machine and that little change rippled through our poor server like a lady Gaga Meat Dress through the VMA’s. Needless to say, it wasnt pretty. The full set of events may never
Changing the owner of nearly anything in SQL Server
about 1 year ago - 1 comment
The other day we were going through some old scripts and had a huge discussion about changing object ownership in SQL. Forever the only answers were to recreate the objects or use the stored procedures: sp_changeobjectowner or sp_changedbowner. Alternatively at times there were those of us who used some other undisclosed hack of system tables
Something old is something new
about 1 year ago - No comments
For the new year I have decided to try something different with a series of small regular posts.
Dealing with our large team of developers and our DBA team as well, I often run across interesting discussions about small things that are easily overlooked. Often times these discussions end in a exclamation of “I knew that!!” Of
Im a Winner!
about 1 year ago - 1 comment
And no, I dont mean in my mothers eyes, thats a given.
I won the Ipad/SQL Monitor Contest that Redgate was sponsoring over on Grant Fritcheys Blog
Im thrilled to have won!! Ive been eyeing Ipads for quite some time but, the novelty & cost has kept me at arms length.
Im always in the market for DBA tools that can make
SQL Server 2008 & IPV6 vs Symantec
about 1 year ago - No comments
Had a strange error on a SQL 2008 cluster the other day,
The OS was Windows 2008 R2
We kept getting messages that the cluster node was offline because the Quorum was unavailable. This made little sense as both nodes in this cluster were online and the Quorum disk was available. We could ping across the heartbeat,
