Home > IT Answers > Storage > In an effort to free up SQL Server disk space, how can a DBA know when it is time to drop developers test databases from local servers?
SQL Server Ask the Experts
2,585 pts.
 In an effort to free up SQL Server disk space, how can a DBA know when it is time to drop developers test databases from local servers?
Disk space, SQL Server administration
Apart from maintaining a SQL Server checklist to check in with developers, how can a DBA know if restored databases on local servers - that were gotten for developers to test – can be dropped after a few days? This would help increase the available SQL Server disk space. Let’s say about 7 user databases are on a local server of which 3 were gotten from production locations for developers to use for some tests. How does a DBA know whether to drop those 3 databases from local servers as the developers completed their test, if developers don’t notify DBAs?

Software/Hardware used:
ASKED: April 25, 2008  2:23 PM
UPDATED: April 25, 2008  9:56 PM
RELATED QUESTIONS
Answer Wiki:
The only way to know for sure is to go to the developers and ask them. You could go and setup SQL Profiler to monitor the database, but just because there isn't any activity on the database doesn't mean that the are done with the database.
Last Wiki Answer Submitted:  April 25, 2008  9:28 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.