Witness server

Tech-Archive recommends: Speed Up your PC by fixing your registry


Hello,

I am trying to setup a SQL 2005 SP2 mirroring with auto failover. I need a
witness server for such configuration. Is the witness server a didicated
server for the mirorring set or I can use another stand alone SQL 2005 SP2
production server as a witness server (shared as a witness server role and
regular SQL production server role to service another application to access
the other databases on the "witness server"? If yes, is there any impact on
the SQL server that acts also as a witness server?

Thanks.

.