GilaMonster (12/18/2014)
The other thing to think about is that the database is the unit of restores. Will you ever be required to revert customer 42's data back to how it was yesterday 2pm without affecting the other customers? If so, that's a strong indication towards separate databases.
Thank you Gail, I'd forgotten that point!
Taking that a step further, while you could, in theory, restore a copy of the DB to recover *just* customer 42's data, how long would that take with one DB for all customers?
Imagine if your DB is around 7-800GB (or into the terabyte range) and you need to restore a copy to recover a measly 256MB of data (customer 42 is a smaller customer)