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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Unused databases

Author  Topic 

CanadaDBA

583 Posts

Posted - 2011-02-17 : 11:03:09
There are many unused databases in my DEV and QA environments. The space they take is about 700 MB. So, wouldn't be much saving in space if I drop them. But my concern is to know that are they using SQL Server's resources? What kind of benefits the server would gain if I drop them?

Note that we have scripts to recreate them and populate the production data whenever we need to do that.

Thanks!

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-02-17 : 11:24:44
If they aren't being used, then the only resources they are taking up is disk space.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -