Filemon lets you see all file system activity in real-time.
It is useful to discover file requirements for a certain application or to discover the location of files being written to.
You can find more information about this tool at http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx