Forum Replies Created

Viewing 15 posts - 1,231 through 1,245 (of 9,244 total)

  • RE: Mirror logshipping fail over senario test

    jamessdba (6/22/2016)


    Hi experts please provide your inputs on below scenario

    we have Server (A,B-one n/w)C--on diffrent n/w

    A-> B Mirrorg Configured

    A-> C Logshipping Configured

    if AB server/n/w fails our intention is to ...

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

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

  • RE: Level 6: Analyse & Deploy an AlwaysOn Availability Group

    Hi Brandie

    thank you for your responses, I'll address all of the questions here in this single post if that's ok.

    Brandie Tarvin (6/22/2016)


    Quick question on the backups... Does Always On take...

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

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

  • RE: Sql alwayson ag

    Talib123 (6/13/2016)


    Surely SAN replication would just copy the damaged page?

    yes, it would

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

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

  • RE: Copy Database Backup from One Server to Another

    previously I've used powershell to do this, works very well

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

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

  • RE: Availability Group Errors

    Is it a virtual environment?

    is this a same-site or cross-site cluster?

    how many NICs does each node have?

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

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

  • RE: Always On, as a DR site.

    Leonard Rutkowski (6/1/2016)


    1. Currently, we use cluster for HA, and SAN replication for DR. During a DR test, we 'break' replication, and mount the replicated LUNS on our UAT system....

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

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

  • RE: AlwaysOn failover with domain users and groups

    Joie Andrew (6/2/2016)


    When a node is the owner of the listener the NIC on that subnet is listening on the listener IP as well as the IP it is primarily...

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

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

  • RE: Reporting server setup

    SSRS security may also be used to provide separation for users within the same SSRS instance.

    no real need for multiple instances or even multiple servers

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

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

  • RE: Moving drive from one server to another

    importing the RAID array on the new server may be possible depending on the controller.

    However, I would take a full backup of the drive first to prevent any data loss

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

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

  • RE: SQL Server 2016 Standard Availbality groups

    as Kevin has said just be aware of the limitations before you set this all up

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

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

  • RE: AlwaysOn failover with domain users and groups

    at a guess I would say the application is connecting to the primary instance, when failover occurs this is when it breaks.

    Confirm the client connection string please

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

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

  • RE: Help trying to setup a home lab - The certificate chain was issued by an authority that is not trusted

    have you successfully joined the machine to the domain?

    Can you provide a little more detail at all?

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

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

  • RE: Restarting SQL Server service in a clustered envrionment

    Siberian Khatru (5/24/2016)


    Does anyone know for sure whether or not restarting the SQL Server service on the active node of a clustered SQL Server 2012 environment (2 nodes) will precipitate...

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

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

  • RE: AlwaysOn failover with domain users and groups

    definitely states AG

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

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

  • RE: AlwaysOn connections

    vincenzo_capelli (5/27/2016)


    Hi,

    I have implemented AlwaysOn, now before to switch on secondary replicas I would like to be sure all applications have been modified to connect into the AlwaysOn listener.

    Do you...

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

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

Viewing 15 posts - 1,231 through 1,245 (of 9,244 total)