Forum Replies Created

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

  • RE: alerts on AG

    ramyours2003 (9/4/2015)


    Yes both are in sync ..

    What about the group level is it healthy?

    How many secondary's do you have?

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

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

  • RE: trouble shooting the always on

    ramyours2003 (9/3/2015)


    can any one provide the document on trouble shooting the issues on always on in sql 2102

    Check my stairway series on this site, this will give you the base...

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

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

  • RE: Always on

    Then there should be no failed create file operations

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

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

  • RE: alerts on AG

    Are the primary and secondary synchronised?

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

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

  • RE: SQL with High availability, disaster recovery and online (read only) reports availability

    shamshad.ali (9/2/2015)


    Can you please share the diagram, it will be easy to understand then, how it is implemented.

    Have you even bothered to read my stairway article linked above?

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

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

  • RE: dynamic quorum

    muthyala_51 (9/3/2015)


    get alerts from that node that it's not healthy or it not available due to the monitor server not able to communicate with it.

    Which monitor server?

    muthyala_51 (9/3/2015)


    If this...

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

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

  • RE: PDF into SQL DB

    Yes it is a LOB. To select\insert the PDF you need to call the appropriate stream reader\writer to access the binary column in the table where the PDFs are stored.

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

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

  • RE: dynamic quorum

    muthyala_51 (9/2/2015)


    A question for you

    You have nodea and nodeb on site 1 and node c on site 2, you have configured quorum for Majority Node Set, each node has a...

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

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

  • RE: dynamic quorum

    muthyala_51 (9/2/2015)


    Perry,

    I was referring to this document, on disabling the vote system--

    https://msdn.microsoft.com/en-us/library/hh270280.aspx

    I assume you're referring to this section of the above link

    microsoft WSFC quorum


    In order to simplify your quorum configuration...

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

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

  • RE: dynamic quorum

    muthyala_51 (9/2/2015)


    Perry,

    I was referring to this document, on disabling the vote system--

    https://msdn.microsoft.com/en-us/library/hh270280.aspx

    Exclude secondary site nodes. In general, do not give votes to WSFC nodes that reside at a secondary disaster...

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

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

  • RE: SQL with High availability, disaster recovery and online (read only) reports availability

    To add

    Alwayson availability groups do have a certain limitation especially around network performance and redo on readable secondarys.

    Depends on the expected volume as to how it affects the 2 areas...

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

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

  • RE: Always on

    Yea but do the folder paths also match?

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

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

  • RE: Always on

    The drives and the folder paths where the database files reside?

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

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

  • RE: Always on

    The drives and the folder paths where the database files reside?

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

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

  • RE: dynamic quorum

    muthyala_51 (9/2/2015)


    The reason why i said two is because the other data center node doesn't participate in the voting system. We manually disabled it following the msft recommendation.

    But it...

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

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

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