• So you restored an older Prod backup over the current version of Prod?

    This means none of the multiple login suggestions that were made will work. You can't prevent a sysadmin from restoring over a database with its own backup.

    However, if you want to restore databases from production to Dev, do what we do in our environment. Build a job on the Dev database that pulls from the Production backup repository and restores. Then you have something that you don't have to rewrite each time the request is made and you don't have to worry about switching environments in SSMS because the job will only run against Dev. (Make sure there are no Linked Servers that could confuse the issue).

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.