Forum Replies Created

Viewing 15 posts - 3,886 through 3,900 (of 9,244 total)

  • RE: clustering- quorum drive

    Can you post the output please

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

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

  • RE: Log Shipping

    can you detail the steps you used to deploy the log shipping plan and whether using GUI or scripted

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

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

  • RE: clustering- quorum drive

    muthyala_51 (11/14/2013)


    I tried it on a test server using the command prompt command. I can move the cluster group but i still see the quorum drive on the passive node...

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

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

  • RE: Multiple Data Files

    shindle 17293 (11/14/2013)


    I have a db that has 3 data files. The first data file is on one drive and the remaining two on another. All three were set to...

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

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

  • RE: Log Shipping

    why rename the job?

    For each instance you want to monitor an LSAlert_instancename job is created.

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

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

  • RE: Log Shipping

    A single instance can be used to monitor multiple log shipping plans

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

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

  • RE: how sql server failover cluster 2012 installation works on top of sql server 2012 that already installed

    RTaylor2208 (11/13/2013)


    If I am interpreting your post correctly are you saying that you have two physical servers participating in a windows cluster.

    On each node you've a SQL server installation you...

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

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

  • RE: Permission required to install sql cluster

    The setup account requires administrator permission to carry out the install. The service account should be a basic user account.

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

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

  • RE: Script to determine if two instances are on the same node

    Running multiple instances on sql on the same node is not uncommon or bad, in fact its a good way to get the most from your hardware as long as...

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

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

  • RE: Script to determine if two instances are on the same node

    just query this from each instance and compare the values, no need for reams and reams of code

    SELECT SERVERPROPERTY('Computernamephysicalnetbios')

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

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

  • RE: Database went into Restoring State for unknown reason

    Grant Fritchey (11/7/2013)


    GilaMonster (11/6/2013)


    Restoring or recovering?

    A DB will go restoring if someone runs BACKUP LOG ... WITH NORECOVERY ....

    In what might be an epic role reversal, don't you mean RESTORE...

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

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

  • RE: Disk space gets full and cluster goes offline

    Ryan007 (11/11/2013)


    Thanks Perry

    But disk might get full due to huge transactions. So to prevent this, is there anything that can be done so that LUN does not go offline if...

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

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

  • RE: Moving from mirroring to AlwaysOn for SQL Server 2012

    Reg_Mayfield (11/8/2013)


    When I stepped thru the process on the first server (Primary server) when I got to the dialog screen that asked for "Select Servers or a Cluster" I am...

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

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

  • RE: Disk space gets full and cluster goes offline

    at the Netapp filer level if the LUN space depletes the LUN goes offline, this in turn will take the disk offline in Windows.

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

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

  • RE: Add third node sql cluster

    That is correct

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

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

Viewing 15 posts - 3,886 through 3,900 (of 9,244 total)