• I periodically have to restore to test instances and while its certainly not foolproof, the first time I do this, I script all the restore and update T-SQL out into a text file and paste into SSMS from there. This way, I have a reference and only had to type it in correctly once. Plus, psychologically, it just seems to be reassuring to me.

    I also really really like the idea as mentioned of having separate logins and this used to be the norm for the sort of work I used to do, but nowaday's getting Windows administrators to even consider this seems to be a lost cause, and from what I've read, many SQL Server folks are probably of the same mindset.