Knowledgebase

MSSQL Mirroring / Failover?

Posted by wubwob, 07-08-2008, 11:35 AM

I'm building the infrastructure for a live event site. I have specced 8 app servers but I'm still unsure with regards to MSSQL. The site functionality makes a single write to the DB with no reads. A simple option would be to have a MSSQL DB instance on each of the APP servers and simply collate the information after the event. I've also been looking at the mirroring function of 2005 as it would mean we could get away with two MSSQL servers instead of 8. Has anyone used MSSQL 2005 Mirroring? Is it easy to setup and maintain? Any caveats?

Posted by activelobby4u, 07-08-2008, 02:58 PM

You could use a dedicated mssql server for 8 app servers and create an additional backup server/database or proper backups scheduled every hour to avoid the consequences of input of wrong data

Add to Favourites

Print this Article