Date on MDF file in Windows Explorer

Using SQL Server 2000 on Windows 2000 - if I look in
Windows Explorer, the date on the MDF file does not always
match the date the last time data was entered. Auto Close
is not selected on the options tab. When does this date
(modified) change? What causes the change?
ThanksThe database engine writes data from the log and from
memory when it wants to. Data you enter goes into the
log, from there it's up to the engine.
Also, any backup and maintenance plans touch the database
and change the modification date/time.
>--Original Message--
>Using SQL Server 2000 on Windows 2000 - if I look in
>Windows Explorer, the date on the MDF file does not
always
>match the date the last time data was entered. Auto
Close
>is not selected on the options tab. When does this date
>(modified) change? What causes the change?
>Thanks
>.
>|||This is an interesting topic. Nowhere in any documentation will you find a
detailed information regarding this. But it's easy to test. Below is what
I've found in my pilot test:
What changes the database timestamp?
1. ALTER DATABASE pubs
MODIFY FILE (name = pubs, size = 5 MB)
2. sp_rename 'pubs', 'pubs2'
3. sp_dboption 'pubs', 'single', 'true'
What does not change the timestamp?
1. BACKUP DATABASE
2. DBCC DBREINDEX
3. ALTER DATABASE
MODIFY FILE (name = pubs, maxsize = 25 MB) or filegrowth = 1 MB.
There must be more in SQL server that will do the job. Anyone interested,
please following up on the post.
Richard
"Steve z" <szlamany@.antarescomputing.com> wrote in message
news:003601c35780$37300470$a401280a@.phx.gbl...
> The database engine writes data from the log and from
> memory when it wants to. Data you enter goes into the
> log, from there it's up to the engine.
> Also, any backup and maintenance plans touch the database
> and change the modification date/time.
> >--Original Message--
> >Using SQL Server 2000 on Windows 2000 - if I look in
> >Windows Explorer, the date on the MDF file does not
> always
> >match the date the last time data was entered. Auto
> Close
> >is not selected on the options tab. When does this date
> >(modified) change? What causes the change?
> >
> >Thanks
> >.
> >