Forum Replies Created

Viewing 15 posts - 7,831 through 7,845 (of 9,241 total)

  • RE: setting up a 2 node cluster

    rdecker (8/4/2010)


    Hi Perry,

    If we used a witness then it would be a 2 node cluster anymore. Unless I'm mistaken a majority node set with a witness would require at...

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

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

  • RE: setting up a 2 node cluster

    WayneS (8/4/2010)


    Perry Whittle (8/4/2010)


    Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node set with a witness and put the Quorum mirrored...

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

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

  • RE: Restart SQL Server service on a cluster environment

    you're wlecome.

    you would need to either move the group via cluster administrator or pull the public network connection on the active node for the service to fail over!

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

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

  • RE: setting up a 2 node cluster

    rdecker (8/3/2010)


    Here is a visual diagram I hope this helps.

    Robert

    Hmm yes, the only issue with that diagram is the Quorum assignment! I would use a majority node...

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

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

  • RE: Restart SQL Server service on a cluster environment

    blue_inelush (8/3/2010)


    an application that will do stop-start for the sql server service. The only problem is that my Sql Server 2005 is installed and configured on a cluster environment and...

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

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

  • RE: Hi i am a sql dba.In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.

    Hi

    also try to post in the correct forum. Posting a topic from which i can see has nothing to do with high availability in the HA section is not a...

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

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

  • RE: configuring database mirroring first time ...please help me..urgent

    ALZDBA (7/31/2010)


    What else would be the purpose of a mirrored db, if you still lose time when you cannot afford it (i.e. at failover time) ?

    Meaning if you would...

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

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

  • RE: configuring database mirroring first time ...please help me..urgent

    the failover partner connection string parameter is only required if confuring automatic failover. You need to be using either the SQL native client or ADO.NET

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

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

  • RE: Shrinking database vc Windows defragmentation

    Hi

    shrinking or growing a database will affect the database file size and ultimately the location of portions of the file on disk (they won't always be contiguous).

    The OS file...

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

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

  • RE: SA account in windows authentication mode.

    Bhuvnesh (7/26/2010)


    this is new to me. are you sure for it ?

    Yes!!

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

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

  • RE: Firewall config for access to remote databases at another network/domain from SSMS client

    Lowell pretty much has the take here, dynamic ports on sql server instances will give the issues you are seeing only upon instance restart though!

    Depending on how you connect you...

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

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

  • RE: Sql Server Memory Issue

    Ashaaban

    what edition is your SQL Server 2008?

    i.e. standard, enterprise?

    If you're using Standard edition the lock pages in memory option is ignored unless you have SQL Server patched to SP1...

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

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

  • RE: Installing SQL Server 2008 R2

    where did you get the DVD image from?

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

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

  • RE: upgrading from 2000 enterprise to 2005 standard

    to re use the hardware, i would uninstall one node leaving the cluster effectively a single node cluster. I would then temporarily virtualise this system to keep it running side...

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

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

  • RE: setting up a 2 node cluster

    From memory the installer wont let you select a shared drive, if you do it warns that the drive is a shared drive and forces you to make another selection

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

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

Viewing 15 posts - 7,831 through 7,845 (of 9,241 total)