JackedUp
15 years agoLevel 4
SQL DB Modified Date
Hi All,
Current setup:
EV 803
SQL svr 2005
Domino Journaling only
I had an issue today where the EV was not seeing the SQL server. I wound up having to reboot the EV server, ran the connectivity test, and everything seems to be working fine. I did notice on the SQL server that the modified dates of the vault databases have not been updated since December???????? I checked the EV reports folder daily to assure the journaling process is working correctly and have no journaling issues since December, till today obviously. Any ideas why the modified date would not be updating?
AndrewB is 100% correct
if you set up a database with 1GB initial size and to auto grow by 1GB and you create that on 01/01/2010, then the modified date would be 01/01/2010, and if the auto grow doesn't occur for a year, then the modified date for the entire 2010 (unless you perform shrinks) will remain at 01/01/2011, but if it then auto grows to 2gb on 01/01/2011 then it will change the modified date to that until it next auto grows or shrinks