Forum Discussion

JackedUp's avatar
JackedUp
Level 4
15 years ago

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?
Best Practice
Database
Enterprise Vault
Information Governance
Monitoring
Performance
SQL
Troubleshooting
  • JesusWept3's avatar
    JesusWept3
    15 years ago

    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

4 Replies

Sort By
  • AndrewB's avatar
    AndrewB
    Moderator
    15 years ago
    Hi JackedUp,
    My explanation did not make sense? Just wondering for the future when I post so I can try to be more concise.
  • JesusWept3's avatar
    JesusWept3
    Level 6
    15 years ago

    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

  • AndrewB's avatar
    AndrewB
    Moderator
    15 years ago
    I'm not a SQL expert but I'm pretty sure it wouldn't update the date and time stamp until the file is modified as far as the OS is concerned, which would be file grows or shrinks or if the file is closed say during a dismount, reboot, etc.