Correlation between MDF, LDF and BAK file whilst execution a database restore
I love it when things look the way they are supposed to be.
Look at the following Performance Montor graph where a +240GB database is being restored.
Location of the files:
- BAK file on E volume ( turqoise or apple-blue-sea green color as I call it)
- MDF file on F volume (yellow color)
- LDF file on G volume (pink color)
Look at the correlation between the backup and MDF file. Also look at the difference in transactions between the MDF and the LDF file.
Steve