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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!