Forum Discussion

joshlabtech's avatar
joshlabtech
Copper Contributor
Aug 07, 2023
Solved

What action must be done for the DB modified date to be effected?

Hi Community,

 
I tried to create something in my ERP, but the date modified of that DB is still showing older dates.
May I know what action must be done for the DB modified date to be effected?
 

 

Thank you!

 
Thank you!
  • nimesht's avatar
    nimesht
    Aug 07, 2023

    Right click on the database in the SSMS Object Explorer window, and go to properties, then Files tab and check the path.
    If this seems complicated, suggest to gather some knowledge about SQL Administration as meddling with the SQL files is not recommended.

5 Replies

  • nimesht's avatar
    nimesht
    Iron Contributor
    Why are you looking at the data file modified date?
    Is you are able to see the changes with queries, this should not bother you
    • joshlabtech's avatar
      joshlabtech
      Copper Contributor
      Hi nimesht,

      Right now, I'm not sure which DB in my server is my Database in Data folder. I was hoping if I did some entries in my ERP, I can see the date modified.

      Can you advise?
      • nimesht's avatar
        nimesht
        Iron Contributor

        Right click on the database in the SSMS Object Explorer window, and go to properties, then Files tab and check the path.
        If this seems complicated, suggest to gather some knowledge about SQL Administration as meddling with the SQL files is not recommended.

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    You can not rely on the "Modified date" in Windows Explorer for database files.
    For better performance SQL Server bypass all OS functions and access the database directly in "raw mode".
    • joshlabtech's avatar
      joshlabtech
      Copper Contributor
      Hi olafhelper,

      Can you advise how can I determine which DB is the live DB?

Resources