Copy one database to another (existing) database on the same server
I suspected multiple backups might exist in this backup file.  If you run:

RESTORE HEADERONLY from disk = [tempfile]


this will show all the backups that are in the file.  You are not restoring the latest backup, use FILE=X to restore the appropriate backup.