I have a SaaS e-commerce app. When clients stop using the service I disable their SQL Server Database and User Account rather than delete them.
Do these disabled databases cause any concerns related to stress on the server or SQL Server limitations on databases? For example is the any type of overhead just leaving them there? I have our backup tasks setup to not make backups for disabled databases.
I use SQL Server 2008 Web Edition.