We are three DBAs managing more than 3000 SQL Server databases. Using more than 100TB of storage. Databases range from a few MB til 7-8 TB databases.

Our environment uses SQL Server 2005/2008/2008R2 and a few 2012s.

We have automated the environment to a very high degree, using SQL Server/SQL Agent and PowerShell. Including automatic discovery, backup, maintenance, reporting, as well as some migration, recovery, and capacity management functionality.

-

Jakob