Forum Replies Created

Viewing 15 posts - 2,041 through 2,055 (of 9,244 total)

  • RE: AlwaysOn vs Mirroring

    AlwaysOn offers the ability to have multiple readonly replicas, failover is now managed by the WSFC subsystem and can incorporate the inclusion of a TCP IP listener. Aside this the...

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

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

  • RE: Access denied to Cluster storage when restoring 2005 Full Text DB to 2014 cluster

    FT catalog storage changed between SQL server 2005 and 2008, please see this link

    https://msdn.microsoft.com/en-us/library/ms142490.aspx#Attaching_2005_ft_catalogs

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

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

  • RE: AlwaysOn fails every hour

    i1888 (6/10/2015)


    Cluster resource 'XXXRes' of type 'SQL Server Availability Group' in clustered role 'XXXRole' failed.

    Clustered role 'XXXRole' has exceeded its failover threshold. It has exhausted the configured number of...

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

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

  • RE: EMC VNX SAN RAID5

    dan-404057 (6/5/2015)


    Hi Everyone,

    We are in the process of purchasing a new SAN for our entire organization: SQL Server, file servers, VMs, etc. The consultants we are working with are...

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

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

  • RE: How Do I check The "Always On Auto Failover" - In Which scenario ?

    read my stairway to AlwaysOn starting at this link

    http://www.sqlservercentral.com/articles/FCI/107536/[/url]

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

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

  • RE: HighAvailability Groups service restart

    Joshua D Gang (6/9/2015)


    I plan on doing the following.

    1. Manually fail over to the secondary, which does not have the priority boost set to true

    2. change the setting

    3. restart the...

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

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

  • RE: Just want to make sure I have my facts straight about autogrowth.

    Duran (6/9/2015)


    Hey Everyone.

    I just wanted to confirm something, if I have given the right to Instant File Initialization, the same process occurs when the files has to grow (everything stops...

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

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

  • RE: TDE Table Data Encryption

    If anyone wants to know why Gail said this, read my post immediately above

    GilaMonster (6/9/2015)


    I'd be far more concerned about the implications for restores, especially restores in the case of...

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

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

  • RE: TDE Table Data Encryption

    Welsh Corgi (6/8/2015)


    What am I missing?

    This

    Welsh Corgi (6/8/2015)


    -- Warning: The certificate used for encrypting the database encryption key has not been backed up. You should immediately back up the certificate...

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

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

  • RE: TDE Table Data Encryption

    BL0B_EATER (6/9/2015)


    Ouch... sounds like my worst nightmare come true.

    No it would be worst and would likely result in you typing your resume

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

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

  • RE: TDE Table Data Encryption

    GilaMonster (6/9/2015)


    Why are you using it? Do you understand the impact? Do you understand what it means for backup and restore?

    Already asked and had this response

    Welsh Corgi (6/9/2015)


    Perry Whittle (6/9/2015)


    TDE...

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

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

  • RE: TDE Table Data Encryption

    Welsh Corgi (6/9/2015)


    It needs to be enabled to prevent sensitive from being displayed?

    Thanks.

    Boooom and that's NOT what TDE does, it does not stop someone from querying the database and reading...

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

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

  • RE: Can't connect to the SQL Server 2012 active node

    firewall in operation maybe, have you checked this?

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

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

  • RE: Can we use one of the shared drives (Data/log/bkp/temp) for configuring MSDTC ?

    you should ideally use a separate disk for the DTC resource

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

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

  • RE: How Do I check The "Always On Auto Failover" - In Which scenario ?

    When the alwayson availability group fails over the listener will be interrupted. It is a cluster resource and will be stopped on one node then started on another

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

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

Viewing 15 posts - 2,041 through 2,055 (of 9,244 total)