Forum Replies Created

Viewing 15 posts - 631 through 645 (of 9,244 total)

  • RE: SQL AlwaysOn install requirements

    please read my stairway to alwayson at this link

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

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

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

  • RE: My db has a lot of PAGELATCH_SH waits going on

    TheSQLGuru - Friday, July 21, 2017 11:44 AM

    Perry Whittle - Friday, July 21, 2017 6:45 AM

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

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

  • RE: SQL Server 2014 AlwaysOn failover

    are you implying that database2 fails to move to either of the partner replicas?
    If this is the case, try removing it from the AG and re initiliasing the secondarys

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

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

  • RE: Backup and Restore

    if the dba already has a backup chain then you need to ask them to provide all the files including the full backup to be able to restore the database...

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

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

  • RE: After sql upgrade from sql 2014 to sql 2016 failover on 2 node windows cluster fails

    check the cluster events for more info and the sql server error log

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

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

  • RE: SQL Server geo-cluster 2016

    As i said  please read my stairway to Alwayson, your understanding of this is way off and it will help you.
    Now, to the replies

    hurricaneDBA -...

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

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

  • RE: SQL Server geo-cluster 2016

    hurricaneDBA - Monday, July 24, 2017 5:01 AM

    Which one is the best practice?
    WSFC + FCI
    FCI + AG
    WSFC + FCI + AG

    please...

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

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

  • RE: SQL Server geo-cluster 2016

    hurricaneDBA - Monday, July 24, 2017 4:27 AM

    Dear ED
    The only answers i have are:
    Availability we dont have any applications running 24/7 but...

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

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

  • RE: SQL 2016 SSRS failover cluster install

    robin.pryor - Friday, July 21, 2017 11:37 AM

    I opted to go a completely different way, but I do see enough evidence to...

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

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

  • RE: SQL Server geo-cluster 2016

    hurricaneDBA - Sunday, July 23, 2017 3:48 AM

    Dear Everyone
    Ikeep reading online...

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

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

  • RE: Lost DMK (Database Master Key) password.

    what is the DMK used for, is this a TDE protected database?

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

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

  • RE: Install SSIS on an existing Cluster - SQL 2008 R2

    where did you install the feature to?
    search the local drives for the ini file

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

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

  • RE: SQL 2016 SSRS failover cluster install

    as i said above it's not cluster aware.
    install clustered features separately to non clustered.
    The installer doesnt stop you when creating the instance, when maybe it should, the add...

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

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

  • RE: Transaction Log Shipping restore on demand - good idea for UAT testing?

    aaron.reese - Friday, July 21, 2017 3:21 AM

    Is is safe to keep these transaction logs on a drive until we need to...

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

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

  • RE: Fail over failed

    WhiteLotus - Sunday, July 16, 2017 7:50 PM

    Hi All,

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

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

Viewing 15 posts - 631 through 645 (of 9,244 total)