Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: Win date modified field on MDF files

    I'm an Oracle DBA and just getting used to MS Sqlserver. I noticed that the windows explorer "date modified" field for my database files ( .MDF files ) doesn't change much even though there is activity going on. Sometimes it doesn't change for a week.

    Is this the expected behavior? Could it be that no data is changing in my database? ( I find that hard to believe)

    Thanks for any insights.

  2. #2
    Join Date
    Sep 2003
    Dallas, Texas

    Re: Win date modified field on MDF files

    Data changes will not change .mdf. Only when you restore the database or enlarge the .mdf size it would considered as 'modified'.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts