I wasn't there when the problem occurred. My understanding is that my coworker intended to restore the production database over the test database but forgot to change the path...

It's fixed now.

This morning I tried attaching the database again and it worked. Yesterday attempts to attach didn't work but I had only tried before we restarted SQL Server.

The database in question is just a "test" version of our production ERP database. We have a bunch of clients installed that allow users to try things out in...