Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nomadnate
Starting Member
3 Posts |
 Posted - 2009-08-27 : 15:17:00
|
| Hi,We're migrating one of our key servers to a new OS install on VMWare and than upgrading the databases from SQL 2000 to SQL 2005.There are over 40 databases (varying in size) that have accumulated on this install over the years, and I was wondering if there is an easy way (probably dreaming) to determine exactly what databases are actually in use? Much appreciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-27 : 16:31:11
|
You can run a trace...but it's up to you to decide how long to run it for.If there are some you think are not in use, but aren't sure, you can go ahead and migrate it, then set it to restricted_user, or read_only or even rename it.If errors pop up you can set it back in seconds.If no errors pop up for some period of time (90 days?) can drop it.Keep the backups though  |
 |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-09-03 : 12:44:45
|
| Run a job in the behind & catch you if any users connecting to the database & save the details into another table or text file.Thanks,Krishnawww.SQLServer.in |
|
|
|
|
|
|
Verifying what databases are in use