Forum Discussion
joshlabtech
Aug 07, 2023Copper Contributor
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!
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
Sort By
- nimeshtIron ContributorWhy are you looking at the data file modified date?
Is you are able to see the changes with queries, this should not bother you- joshlabtechCopper ContributorHi 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?- nimeshtIron 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.
- olafhelperBronze ContributorYou 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".- joshlabtechCopper ContributorHi olafhelper,
Can you advise how can I determine which DB is the live DB?