December 10, 2008 at 1:57 am
Hey
I was wondering if there is a way to find the last date/time the database was used.
Iv done some searching on this here site and on Google but i come up short? (other than 3rd party software like Lumigent Adit DB) is there maybe some way to get this info as i need to get rid of some databases but i need to be sure they not in use???
Perhaps i should just detach and wait to see who moans 😀
December 10, 2008 at 2:01 am
You can use the profiler and the database's ID as a filter
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 11, 2008 at 1:03 am
Thanks alot
Will definately give that a try
December 11, 2008 at 1:37 pm
Keep in mind, using profiler will give you the information going forward, as long as the trace is running. It will not give you past history. And it can impact performance so you may want to fire it up on a little used server and point to the server in question.
twebster (12/10/2008)
Perhaps i should just detach and wait to see who moans 😀
You can also, simply take it offline and if it is in use, simply put in back online. Probably quicker if someone does "moan"! 😉
-- You can't be late until you show up.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply