February 2008 - Posts

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

Posted by Steve with no comments
Filed under: