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

[joshlabtech]

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!

[#2]

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".

[#3]

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

[#4]

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?

[#5]

Hi olafhelper,

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

[#6 · Accepted solution]

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.