Post reply

always backup database with encryption

  • September 12, 2021 at 12:00 pm

    #3928895

    Hi,

    is there a way to force that all backup database and backup log that runs on the server will be enforced with the encryption(if not specifying the encryption the query will be terminated )?

    THX

     

  • September 13, 2021 at 12:10 pm

    #3929079

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • September 13, 2021 at 12:51 pm

    #3929088

    There is nothing to force the keyword "WITH ENCRYPTION", if you want every backup to be encrypted look at TDE instead, that will ensure it is encrypted even if you forget to specify WITH ENCRYPTION

  • September 15, 2021 at 12:08 am

    #3929637

    BWAAAA-HAAAA-HAAAA!!!  I've found that "Penalty of Death" will sometimes work! 😀

    I agree with Ant-Green's statement.  All of our data is encrypted and that means everything and not just SQL Server data and backups.  The best part for me is that our infrastructure folks took care of all that (according to them) so that 1) I don't have to worry about such a thing and 2) neither the DBAs or other power-users could undo such a thing even on purpose never mind by accident .

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

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