How to find out when a database was last updated - 12-07-2005 , 05:10 PM
I want to find out when a database was last updated.
I checked in IE, it shows the creation time and the time last backup was
I looked at the timestamp of the database, that doesn't seem to reflect the
correct date and time, in my case it is showing the date of 12/4/2005 11:00am
whereas I know for sure that the database is being updated since after that.
That was the time I took last backup of this database.
Thank you in advance,
Re: How to find out when a database was last updated - 12-07-2005 , 06:28 PM
Unless you have a trace running you can't. Trace is your best bet to see
if and when a db is being accessed. You can also potentially use some of
the third party Log viewer tools.
Andrew J. Kelly SQL MVP
"Me" <Me (AT) discussions (DOT) microsoft.com> wrote