Post reply

TDE and Filegroups

  • July 16, 2011 at 3:32 pm

    #240941

    Comments posted to this topic are about the item TDE and Filegroups

  • July 16, 2011 at 4:02 pm

    #1353892

    First again!

    Good question - I guessed correctly, but still leaned a new fact for the day. Cool.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • July 17, 2011 at 9:46 am

    #1353959

    Far from being the first to answer the question and most likely not the last to learn more about a complex subject. Thanks Steve for introducing me a facet of SQL that I had not investigated before.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 18, 2011 at 12:42 am

    #1354069

    Good question.

    Thank you.

  • July 18, 2011 at 2:14 am

    #1354079

    Great question - definitely learnt something new today.

    Thanks

  • July 18, 2011 at 2:35 am

    #1354087

    Thank you Steve, I found the answer after searching for sometime 😛

    M&M

  • July 18, 2011 at 3:00 am

    This was removed by the editor as SPAM

  • July 18, 2011 at 3:03 am

    #1354102

    Nice question!

  • July 18, 2011 at 3:30 am

    #1354119

    Interesting question today.

  • July 18, 2011 at 5:46 am

    #1354169

    Good question on a new feature.

    http://brittcluff.blogspot.com/

  • July 18, 2011 at 6:06 am

    #1354177

    Being more of a DB programmer than an admin at the moment, this was a good excuse to learn something I ought to know, certainly in the near future. Thanks for the question!

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • July 18, 2011 at 6:15 am

    #1354181

    Per article (Transparent Data Encryption (TDE) SQL Server 2008 by Roy Ernest, 2009/05/04) implementation will not "fail" but will not complete.

    "If you look at sys.dm_database_encryption_keys, you will see that the column Encryption_state shows that the value is 2 instead of 3. Value 2 means Encryption in progress. Since the filegroup is set as read-only, the encryption state will not be reached."

    Did not do an exhaustive search for other view points or newer info so did not select fail as the answer. The example in the article also was not split with read/write and read only so that may be the difference.

    This is still a great learning tool, I know not to try and encrypt read only filegroups or filestream data.

    Thanks Steve.

    Al Kessler
    It's too bad that
    Common Sense Isn't

  • July 18, 2011 at 6:52 am

    #1354201

    SQL Server has so many "Do-This-only-after-you-do-that-first" and "You-can't-do-that-even-if-you-think-it's-logically-possible" issues that it would take 99999999 QotDs. 😛

    But it's still one of the best DBMSs around.

    Thank you for this question. Learned something new.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • July 18, 2011 at 7:32 am

    #1354227

    Good question but a little difficult for a Monday.

  • July 18, 2011 at 7:56 am

    #1354234

    Got it wrong, but the explanation definitely makes sense. Thanks.

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply