Home Forums SQL Server 2005 SQL Server 2005 Security How to deny restore database in sql server to SA? RE: How to deny restore database in sql server to SA?

  • August 29, 2013 at 5:36 pm

    #1646201

    Brandie Tarvin (8/29/2013)

    K. Brian Kelley (8/29/2013)

    With the different accounts in different environments, they are all admin accounts. Just one works for dev and one works for prod and dev never has the ability to work in prod.

    Unless the same person is doing both and happens to have different SSMS windows open. In which case, it doesn't matter what that person does to prevent these things from happening in the future, they still will happen unless that person double-checks and pays attention.

    But you won't be able to restore prod over dev or vice versa because the boxes themselves cannot see the backups of the other.

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