Ever have a customer request that you take a backup of a database, a restore using that backup, and then tell you that it is the wrong data?
Every now and then it happens, so I decided to put together some t-sql to display details on what was done. The script essentially details when the restored was started, what backup file was used, when that backup was taken, and the name of the source database.
You can read more about it here.
I just love diving into system information to report back details. I believe that being able to pull such details right from the system tables is close to an art form. Every time I come across custom scripts that pull and twist information right from the system I try running them for myself to see how they can best be applied in my shop. I hope the scripts I try to provide at MSSQLTips can help someone else in the same way.
