I think in most cases, it probably deserves to be up a level.

In many environments, you only promote objects to production.

So designing a fool proof process to avoid overwriting Prod with Dev is what should be the main discussion.

As long as the same person has sysadmin in both environments, there is potential to repeat.

Things like color can help, but will not stop fast fingers.

I like Jeff's approach, as you would have to copy the backup to another area to do it.

Similar to ours, where the deveolopers did not have access to those backups.

So you worked with someone else to get the restore done.