Forum Replies Created

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

  • 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" 😉

  • RE: TDE Table Data Encryption

    TDE does not enable Table Data Encryption, it enables Transparent Database Encryption.

    Do you understand what it does and why you would enable it would be my initial question?

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

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

  • RE: 2012 SQL 2 node Cluster Active/Passive with 10 instances

    this is something you'll need to cover with your licensing rep, if you install an instance on a passive node and leave it there it's no longer passive

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

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

  • RE: delete backup files script works well in sql server 2008 r2 but same one fails in sql server 2012 (forfiles)

    BL0B_EATER (6/5/2015)


    Or look into VB which we use in our little shop - IO.File.Delete(FileName).

    Ooooh that's so yester year, here in the 21st century we use this 😉

    $checkdate = (get-date).AddDays(-30)

    $checkpath...

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

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

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