A client of ours has about 70 MS SQL databases on a bunch of single servers running. The client wants to consolidate all those databases into 1 large database. Data wise, we are talking about 3 TB. The client insists High Availability as the data is critical.
I've setup a couple of clusters [Active\Passive] in the past, but I don't know if that's the right choice in this case.
The Client suggested to run the database on 2 or 3 instances. As I'm someone who is specialized in Oracle. I thought that was the main difference with Oracle, that it's not possible to run a database on several instances with MS SQL.I'd love your intake on this one.
asked Jan 26 '12 at 11:43 AM in Default
i think, Log-shipping is not a better choice. as mirroring does better that Log-shipping. I would recommend you to set up cluster for database access availability. Mirroring, replication would cater for disaster recovery. for performance, you can use RAID 10. number of spindles, enough RAM, proper configuration of RAM, Indexing and stats, regular maintenance.
answered Feb 03 '12 at 03:05 PM