I just had the same problem here tonight.

I was making a little test creating extra files for tempDB and ended up with this weird behavior.

Has anyone experienced this? Is this a confirmed bug?

I'm afraid of using ALTER DATABASE REMOVE FILE until I understand what's really going on. :unsure:

[EDIT] For those who are having this problem you must restart your SQL Server engine process for things to show correctly. Stupid me!

Best regards,