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? ...
- 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.
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".
For better performance SQL Server bypass all OS functions and access the database directly in "raw mode".
joshlabtech
Aug 07, 2023Copper Contributor
Hi olafhelper,
Can you advise how can I determine which DB is the live DB?
Can you advise how can I determine which DB is the live DB?