January 8, 2008 at 2:08 pm
Hello Everybody,
Actually we are using SQL 7.0 and now we are planning to upgrade for SQL SERVER 2005 before going to that we would like to delete unused databases for long time and now the question is,Is there any way to find who and when last accessed databases in a SQL SERVER so that we can find out which one is not in use at present.We have closely to 145 db's in server.Can anyone suggest me the best way to do it?
Thanks in advance,
regards
S C
January 9, 2008 at 1:34 am
Well there is no specific way you can get this. Probably you can run a profiler check for the activites against the databases.
January 9, 2008 at 2:25 am
As was suggested, profiler would tell you who is logging in to which databases.
Also, you could look at datetime columns within tables to identify last insert/update time. However, bear in mind, although it may not be in use, it could be a valid historic database.
To be on the safe side though, all databases should be backed up with the intention of migrating them all. This will help you to sleep at night! 😀
January 10, 2008 at 2:57 pm
I agree with Clive, plan to migrate all the databases and keep a current backup of them. However, if you think a database is not being used you can rename it with a _DELETE_ME and listen for who squeals 🙂
January 10, 2008 at 3:36 pm
Does not work this way. People requested their databases back 6 month after we moved them and did not move databases that we were told nobody was using.
Regards,Yelena Varsha
January 11, 2008 at 2:07 am
Better to have backups.
"Keep Trying"
January 11, 2008 at 2:16 am
Yelena Varshal (1/10/2008)
Does not work this way. People requested their databases back 6 month after we moved them and did not move databases that we were told nobody was using.
One word.....Backups! 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply