+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, sims.mdf Date modified in Technical; This may be entirely normal but after checking our backups today we've noticed an oddity. sims.mdf Date modified 01.04.2014. Now ...
  1. #1

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,879
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461

    sims.mdf Date modified

    This may be entirely normal but after checking our backups today we've noticed an oddity.

    sims.mdf Date modified 01.04.2014.

    Now clearly it's being used, it's being updated etc and there's no apparent issues. Most of the database files in that location (FMS, Discover, all the log files) etc have the same date modified.

    Slightly worried but hoping someone can tell me it's OK No access to my other schools remotely for some reason today so I can't check those. Server 2012, SQL 2012.

  2. #2
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    281
    Thank Post
    30
    Thanked 66 Times in 39 Posts
    Rep Power
    20
    Was that when you did the SQL migration?

  3. #3

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,879
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    No, that date has no significance. SQL 2012 was on there since the server was commissioned a year ago and the spring update was done a couple of weeks after.

  4. #4

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,879
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    OK, panic over I think! (although I'm still intrigued as to the reasons - can only assume it does everything in memory and commits when it needs to?)
    Got access to my primaries and they're similar

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,384
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Stupid question, you've hit F5 to refresh the view?

  6. #6

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,879
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    Yup, first thing. Doubled checked in command prompt too.

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,384
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    I've been told it's because its still being written to, so the date stamp won't get updated until that finishes, ie when you next reboot.

  8. Thanks to matt40k from:

    synaesthesia (24th April 2014)

  9. #8

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,879
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    Cheers

  10. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I just stopped and started teh SQL services and the date and time updated.

SHARE:
+ Post New Thread

Similar Threads

  1. Folders and their date modified
    By StephenKing in forum Home Access Plus+
    Replies: 1
    Last Post: 26th February 2013, 03:41 PM
  2. Replies: 6
    Last Post: 10th May 2011, 06:26 AM
  3. [SIMS] Sims client install and Windows7 date error
    By cgilmour in forum MIS Systems
    Replies: 10
    Last Post: 22nd March 2011, 12:40 PM
  4. SIMS Exams-Date issue on importing base data
    By DanSpeed in forum MIS Systems
    Replies: 0
    Last Post: 26th November 2009, 11:49 AM
  5. SIMS Effective Date
    By danIT in forum MIS Systems
    Replies: 2
    Last Post: 18th July 2008, 02:05 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •