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.
If the two logins are different NT logins (rather than SQL logins) two windows simultaneously doesn't matter provided the production NT login doesn't have any access to the development backup filestore and the development db login doesn't have write access to the production db backup filestore; it's a good idea to deny the production service and agent accounts access to development filestore too. You are of course right tat splitting the two functions using SQL Server logins rather than NT logins is not good protection against this sort of foul-up.
Tom