database mirroring 2 servers | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
database mirroring 2 serversSorry about this question but I am new to SQL. I am looking at getting a SQL server to run sage 200. it will be serving 20 â€“ 25 users. the server will be a DL385 g2 with duel Opteron 2.8ghz 8gb ram 6*72gb 15k SAS drives(2 drives raid 1+0 and the rest raid 5). The database I am guessing will be no more than 8gb. Software windows server 2003 enterprise and SQl 2005 standard (both 32bit unfortunately as sage don#%92t support 64bit). We will hopefully at some point be putting in a second small sql server for some access control software as well. We are putting in a second small server so that the sage has full reign of the server. Would I be able to setup database mirroring on the second server for the sage server in case of failure? I apologise in advanced if this is a stupid question
You can setup the mirroring… as long as your HW and SW supports… Read the following article…
Database Mirroring in SQL Server 2005
is there a performance hit on the mail server when the mirroring is setup. i would likt to set this up for redundency and online backup
Nothing official I know about the performance loss, but you have to ensure that the databases queris that are involved are optimized fora better performance.
For the sake of disaster recovery ensure that the principal and mirror have similar configuration, do not use high performance mode and only take over with a manual failover, in my experience. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.