Posted on 2006-05-18
I've been restoring db's for the last few days....after i get the data i need, i restore another file, overwriting it w/the next dump. everything has been going fine. this morning, however, my restore gave me an error -
Server: Msg 5173, Level 16, State 2, Line 1
Cannot associate files with different databases.
now, it was pointing to the Log file, and mind you, it was still running. but, in QA the message tab where the results are given, the msg 5173 was the first message returned, then it was indicating the restore was at 8%...and still running. i've never seen that before. so i killed the restore, checked things out with RESTORE FILELISTONLY, to make sure I hadn't type-o'd, everything appeared fine. so, after killing it, i re-started the restore with the very same .bak file. it's now sitting at 48% complete, still running, and no msg 5173 has been returned. any insight as to why/what's up?