Forum Replies Created

Viewing 15 posts - 496 through 510 (of 9,244 total)

  • RE: MSSQL 2014 : MultiSubnet AOG, ping to the listener Name, is pinging on the DR site.

    For the listener networkname cluster resource you need to set the RegisterAllProvidersIP cluster parameter to 0.
    The default annoyingly is to set all providers ( value=1 ), however, you can change...

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

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

    December 6, 2017 at 5:21 am

    #1970897

  • RE: Readable Secondary Node and Isolation Level

    alex.palmer - Friday, December 1, 2017 6:01 AM

    Thanks for your reply Perry

    I have already read all of your excellent Stairway to AlwaysOn...

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

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

    December 5, 2017 at 10:44 am

    #1970765

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    Jeff Moden - Thursday, November 30, 2017 10:46 AM

    Perry Whittle - Thursday, November 30, 2017 10:29 AM

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

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

    December 1, 2017 at 5:50 am

    #1970245

  • RE: Readable Secondary Node and Isolation Level

    alex.palmer - Friday, December 1, 2017 2:48 AM

    Hi

    I've been looking into using availability groups in our environment.  I've read that if the...

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

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

    December 1, 2017 at 5:49 am

    #1970244

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    Jeff Moden - Wednesday, November 29, 2017 9:26 AM

    Perry Whittle - Wednesday, November 29, 2017 9:03 AM

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

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

    November 30, 2017 at 10:29 am

    #1970097

  • RE: MSSQL Always On High Availability

    myukas - Tuesday, November 28, 2017 9:38 AM

    We are testing a third party package and they want us to configure Always On....

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

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

    November 29, 2017 at 9:13 am

    #1969935

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    master starts first, id is 1
    tempdb is usually just before model, especially evident like Gail said if tempdb is not present as it copies tempdb from model, something which...

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

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

    November 29, 2017 at 9:03 am

    #1969933

  • RE: SQL instance is not starting automatically after reboot.

    anthony.green - Tuesday, November 21, 2017 1:25 AM

    dvprao - Monday, November 20, 2017 4:31 PM

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

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

    November 28, 2017 at 4:22 am

    #1969656

  • RE: Cluster Behaviour

    using cross site shared storage for the quorum is a bad idea tbh.
    If your cluster spans sites consider a fileshare witness on a remote site (not the primary or...

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

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

    November 24, 2017 at 6:46 am

    #1969393

  • RE: What entry should be in sys.servers for an AlwaysOn AG?

    Steve Smith-163358 - Friday, November 24, 2017 4:17 AM

    Hi,

    I've set up a test AlwaysOn AG environment.
    I have 2 SQL Servers, SQL-PRI and...

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

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

    November 24, 2017 at 6:42 am

    #1969392

  • RE: Read Only Routing on Azure Machines

    Jeff Shurak - Friday, November 3, 2017 1:24 PM

    I have a 2 node availability group set up on some azure VMs. As...

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

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

    November 7, 2017 at 4:48 am

    #1966963

  • RE: Mirroring in a WSFC environment

    see my stairway to Alwayson starting at this link

    http://www.sqlservercentral.com/stairway/112556/

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

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

    November 7, 2017 at 4:18 am

    #1966959

  • RE: Migrate SQL Server to new server

    restore the databases first then the logins.
    if you have a login with a default database that doesnt exist the script will error

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

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

    November 7, 2017 at 4:13 am

    #1966958

  • RE: One Cluster to rule them all

    alex.palmer - Friday, November 3, 2017 8:53 AM

    What are the reasons you might want multiple clusters?

    Separation of nodes using completely disparate...

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

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

    November 7, 2017 at 4:11 am

    #1966957

  • RE: SQL 2016 Standard AG Failover issue

    mpoulter35 - Thursday, October 5, 2017 9:26 AM

    When I fail over from my primary to my secondary I receive below error message. ...

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

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

    October 6, 2017 at 4:28 am

    #1962588

Viewing 15 posts - 496 through 510 (of 9,244 total)