Our production database file name is m2mdata01.mdf and we have regularly a daily back up.
Besides, we have a sandbox db. The sandbox db file name is m2mdata50.mdf.
Just today, when I did a restore to the Sandbox from the yesterday's production db backup file I forgot to change the "Restore database files as" from m2mdata01.mbf to m2mdata50.mbf (see the screen shot #1). After the restore was done, I was kind of panic since I thought the subject mistake will cause the live production db to be overwritten by the yesterday's production db file. But when I went to the folder of D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
I didn't see the production db file got overwritten as its date stamped two days ago. (please see the screen shot #2) Why is that? Did the production db file get overwritten or not?
To be honest, I'm very confused. Can you help?