SQL Server, of course, keeps track of everything that affects data in a transaction log, which is periodically rolled over into backup files (at least, if you're being a conscientious DBA it is). But ...

Do you need to find out where the location of your SQL Server's database is? Here's a quick tip.

SQL Server transaction logs A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file.