a.borgeld (1/10/2012)
Specs:VM-ware
Dual core
8 gig memory
64 bit hard and software (Windows 2008 R2 + SQL server 2008 R2)
How many databases can i run on a single instance?
Answer is, it depends :-
1) Size of database
2) Transaction Volume of Database
3) How frequently your database are being refreshed with maintenance plan
4) Number of users connecting.
And on light note, you can have more than 4 database. As you cant limit sql to not create system databases(without replication).
----------
Ashish