Forum Replies Created

Viewing 15 posts - 1,951 through 1,965 (of 9,241 total)

  • RE: AlawaysOn High Availability Group in SQL 2014

    sreenubabu.s (7/2/2015)


    Can you please provide Stairways links ?

    see my first post in this thread on page 1 😉

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

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

  • RE: If SPN is manually registered, will SQL Server try to re register every time it is started ?

    has the account been trusted for delegation?

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

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

  • RE: 3 Node 2014 AlwaysOn - Automatic Failover?

    ItsDaveTime (7/1/2015)


    Given the scenario, if the first datacenter was to go down, I would manually have to failover to the second datacenter? That doesn't make sense for high availability....

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

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

  • RE: New to clustering

    nzone7x (7/1/2015)


    Can someone explain how client application access works? I understood the active/passive model, but active/active/active/active is a fog in the mirror to me.

    Each clustered instance uses its own...

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

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

  • RE: restore BAK file to different server

    you're welcome

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

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

  • RE: Problem with SPN

    It's SETSPN not Getspn or any other variant 😉

    SETSPN -l should be run against the account the sql server service runs under, I'm assuming you know how to find this...

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

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

  • RE: Log Shipping failing.

    Chitown (6/30/2015)


    How and Where would I find this Log Ship Directory?

    You can find the backup folder\share in use by using the following query run against the primary server, look at...

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

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

  • RE: restore BAK file to different server

    Can you post the output of this please

    RESTORE FILELISTONLY

    FROM DISK = 'C:\Extract\REZ_db_201506240733.BAK'

    The problem you have is the fact you're specifying the same file multiple times in the MOVE clause

    RESTORE DATABASE...

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

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

  • RE: TDE does not make the is_master_key_encrypted_by_server value to 1.

    SQL-DBA-01 (6/30/2015)


    Hello Experts,

    Any reason why the TDE does not turn the is_master_key_encrypted_by_server value to 1. The column in table "databases" database.

    Is there anything special to be done to get...

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

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

  • RE: AlawaysOn High Availability Group in SQL 2014

    sreenubabu.s (6/30/2015)


    There is a feature "Automatic fail-over" in "Always on High Availability Group"

    Do we need another node (3rd node) for Automatic fail-over for AO HA Group ? or can we...

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

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

  • RE: Log Shipping failing.

    Chitown (6/30/2015)


    LS Backup job isn't running. Copy and Restore jobs are running fine.

    Ok, now we know where to target our efforts

    Chitown (6/30/2015)


    Both instances are running under Network Service.

    Both Instances are...

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

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

  • RE: Any Way to get the login information - SQL Port Number

    Please post the output of this powershell query, substitute VERSION.INSTID for your sql server version and instance name

    Get-ChildItem "hklm:\software\microsoft\microsoft sql server\mssqlVERSION.INSTID\mssqlserver\supersocketnetlib\tcp\" | ForEach-Object {Get-ItemProperty $_.pspath}

    so if you're using sql server...

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

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

  • RE: Any Way to get the login information - SQL Port Number

    is it a named instance or default instance?

    what is it changing from and to?

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

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

  • RE: If SPN is manually registered, will SQL Server try to re register every time it is started ?

    😉

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

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

  • RE: 3 Node 2014 AlwaysOn - Automatic Failover?

    ItsDaveTime (6/30/2015)


    I have a 3 node 2014 AlwaysOn setup. The primary and secondary are set for automatic failover. The third node, of course, is manual (until 2016). ...

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

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

Viewing 15 posts - 1,951 through 1,965 (of 9,241 total)