Steve Jones - Editor (8/11/2010)

---

The backup file isn't changed. What happens when you do the restore is that the mdf/ldf/ndf are created as sparse files. All reads from these files are redirected to the backup file, while the writes go to the sparse files. So the backup file is intact, but your changes are recorded, similar to a database snapshot.