0

Sorry I am asking a question related to another post(How to add loop of .bak files to restore in single sscript?) where I can not able to add a comment.

Based on script posted in question (How to add loop of .bak files to restore in single sscript?) I have restored .bak files and put .mdf and .ldf files in folder. I have completed restoring on Friday 9th sep 2016 but when I checked this morning .mdf and .ldf have date 10th sep 2016. why the date is showing as 10 sep 2016 instead of 9th sep 2016? please let me know.

Thanks.

Amelia
  • 159
  • 1
  • 3
  • 17

1 Answers1

0

From this SO answer, the LDF file contains the transaction logs from your database. So if any activity occurred on 10th Sep 2016, the LDF file would have been updated with that timestamp.

Assuming the underlying data or state of that database file changed, them the MDF file would also have been updated (q.v. here).

Community
  • 1
  • 1
Tim Biegeleisen
  • 502,043
  • 27
  • 286
  • 360
  • Thanks. does this means do I need to truncate log file? and also four backups log files have same size and two backup log files have same size? are these size differences are correct? please let me know. – Amelia Sep 12 '16 at 11:04