Thursday, March 22, 2012

database file has incorrect modified date

Hello all,
I have a very critical data file currently in use showing a modified date of
5/13/06, and the file is modified very often by an invoice application. When
I attempt to do a restore the file has the right date, I don't understand wh
y
the modified date is incorrect.
Should the file modified date not be very current, although if query for
invoices with date greater than 6/2 it return several. am I missreading the
modified date?
Please help.ITDUDE27 wrote on Mon, 5 Jun 2006 09:05:01 -0700:

> Hello all,
> I have a very critical data file currently in use showing a modified date
> of 5/13/06, and the file is modified very often by an invoice application.
> When I attempt to do a restore the file has the right date, I don't
> understand why the modified date is incorrect.
> Should the file modified date not be very current, although if query for
> invoices with date greater than 6/2 it return several. am I missreading
> the modified date?
> Please help.
You can't go by the last modified date of the mdf/ldf files on the hard
disk, as these dates are only normally updated when SQL Server feels the
need to. I have a database on my main server right now that processes all
the transactions for the company and has a last modified date of 25th May
2006, and a matching LDF with last modified of 15th September 2005.
Actually, most of the files in there are dated 15th Sept 2005, which is the
day this server had them all restored to it when it went live.
Dan|||"ITDUDE27" <ITDUDE27@.discussions.microsoft.com> wrote in message
news:1A118DF6-E57A-428A-935D-AE676D8BEF83@.microsoft.com...
> Hello all,
> I have a very critical data file currently in use showing a modified date
of
> 5/13/06, and the file is modified very often by an invoice application.
When
> I attempt to do a restore the file has the right date, I don't understand
why
> the modified date is incorrect.
>
The last modified date will only change when the file size is changed or the
database is open or closed.
Unless you have autoclose enabled (you should NOT normally) the only time
the database will normally close is when you stop or start the server.
If your server is up for a year, it's not unheard of to have a last modified
date of a year ago.

> Should the file modified date not be very current, although if query for
> invoices with date greater than 6/2 it return several. am I missreading
the
> modified date?
> Please help.

No comments:

Post a Comment