Forum Replies Created

Viewing 15 posts - 7,756 through 7,770 (of 9,244 total)

  • RE: Quorum Conundrum

    Duran (8/19/2010)


    set aside 15GB for a quorum,

    no you dont!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: New Drive added to SQL Server 2005 not showing up

    Brad

    you're welcome, this does trip a few people over 😉

    SQL Server when clustered will only use devices that it has dependencies on!

    Regards

    Perry

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2008 named instance services could not start

    1John19 (1/13/2010)


    Somehow VMWare (I suspected) did not allow the sql named instances to use the same port number.

    this is nothing to do with VMWare, the Windows Operating System will not...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to benchmark my IO and which tool is the best one to go

    SQLIO doesn't test SQL server IO exclusively. It's better for all round IO testing and pushing the SAN to find it's limits. Check the Microsoft documentation that comes with SQLIO!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log Shipping Shrink File

    george sibbald (8/19/2010)


    So if you shrink a data file, rebuild the indexes afterwards.

    which could well end up growing the file again anyway!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Quorum Conundrum

    Duran (8/19/2010)


    Does the number SQL instances have an effect on the size of the quorum? And if so, by how much?

    no, the quorum holds cluster configuration info and logs. 512MB...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log Shipping Shrink File

    Have you checked DBCC Loginfo yet?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL on VMWare

    PaulB-TheOneAndOnly (8/18/2010)


    A system able to support 10K concurrent database requests is not your everyday project.

    Good luck

    True, and IMHO certainly not a virtualisation candidate either!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Quorum Conundrum

    No, it just provides the required node count for the majority scenario to operate correctly and prevent any split brain occurrence!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL on VMWare

    rdecker (8/18/2010)


    Perry, I relayed your message to Russel and he's laughing.

    Not as much as I am I bet 😀 :crazy:

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Restore System DBs to Another SQL Instance

    dso808 (8/18/2010)


    trying to restore the system databases from a clustered server to a NON-clustered server

    I have done this before, its entirely possible. As I said you need to have extensive...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL on VMWare

    not too mention wildly expensive!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL on VMWare

    Or

    Better NOT to get Microsoft involved in the project! 😀

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Quorum Conundrum

    Duran (8/18/2010)


    No cheeky answers, please!

    Would I?? 😉

    Duran (8/18/2010)


    It will be a 2 node failover cluster, and have I read about the elimination of the single point of failure from the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Cluster with Transactional Replication

    yes, but only for publication database. BOL details this more!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 7,756 through 7,770 (of 9,244 total)