Allen Kinsel - SQL DBA

SQL Server, PASS, and other data mishaps

SQL/Windows Clustering Stupidity

By Allen Kinsel, 6 months and 23 days ago

Win98 300x225When 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

Related posts

Share this post

No comments

Be the first to write a comment on this post.

Write a comment

If you want to add your comment on this post, simply fill out the next form:





* Required fields

You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>.

No trackbacks

To notify a mention on this post in your blog, enable automated notification (Options > Discussion in WordPress) or specify this trackback url: http://​www.allenkinsel.com/​archive/​2010/​02/​sql-windows-clustering-stupidity/​trackback/

Follow Me


Tags

Allen Kinsel on Twitter

  • Sitting back with a bucket of popcorn, this has now crossed into pure hilarity, what id give to be in the exchange admin room right abut now 12 hrs ago
  • every one who gets hit by this infection should have their mouse taken away for a month 13 hrs ago
  • Full on spam virus hitting our global address book! are people really that stupid to click an unknown link? #HumanityFAIL 13 hrs ago
  • .@jadionne nothing wrong xcpt u recompile it to change arch log directories. can you imagine #sqlserver needing a recompile to change dir's? 13 hrs ago
  • the db2 community is second only to the oracle community at being rude to their peers...If I see RTFM 1 more time today... sheesh! 14 hrs ago
  • More updates...

Categories

Most Recent Posts

Subscribe

Archives

Next Posts

Latest comments

  • Allowing effective developer access to SQL Server:
    • Karen Lopez: Another approach I use: Be generous in granting privileges in the DEV database (but still lock down the server environment), but don't let Devs promote any DDL to the next environment. Only the DBAs can deliver/apply DDL to the next (usually QA) environment. So if the devs modify their tables/columns without the architect...
  • PASS Summit Community Choice Session results revealed:
    • Andy Warren: Allen, nice job on this. Great to see the community get a chance to participate in building the program and share in the excitement of the upcoming Summit. Andy
  • Community Choice Sessions at the PASS Summit 2010:
    • Allen Kinsel: Thanks, We hope that this will be a good test of community selections, and hope to expand it a bit in the future
    • robert cook: glad you decided to keep blogging and gracias to you and your amigos for giving an opportunity to the sql community for direct involvement with session choices
  • Sql Server and SSPI handshake failed error hell:
    • Robert L Davis: I agree about the reboot. That's why I check SPN's before DC/Kerberos errors. An SPN can be fixed without rebooting, but if the issue is DC connection and no one can log in to the SQL Server, you're down anyway so a reboot shouldn't be out of the question. The problem with having a...
    • Allen Kinsel: I guess should have worded that a little differently, in my experience in a lot of environments kerberos isnt used since its not configured, so it always falls back to NTLM, with only NTLM and no Kerberos in the result list, its usually safe to say that SPN's arent the issue. I...

Most commented posts