always backup database with encryption

  • 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 )?



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

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

  • 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

  • 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)
    Intro to Tally Tables and Functions

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

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