The "File of Type: Selected option: (*bak,*tm)" option isn't an "option".  It simply controls what to display.  If you want your file to have a ".bak" extension, YOU have to...

As a bit of a sidebar, I'd never use a user name and password to connect to the server because they leave your stuff in a batch file in clear...

Heh... it's always the code. 😉  Thanks for the feedback.  I just couldn't imagine it being the simple use of synonyms that was causing the problem.

I absolutely agree that keeping stats up to date is uber important but there's one other thing to check... make sure that the connection strings used by anything and everything...