Steve's SQL Server Blog

My thoughts to your thoughts.

februari 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: feb 01 2008, 11:42 by Steve | with no comments
Filed under: