Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server Mirroring Interview Questions > Can port mirroring be used to create a backup SQL ...

:: Categories ::

Interview Question in SQL Server Mirroring


 

Interview Question :: Can port mirroring be used to create a backup SQL Server


In some newer switches a port can be mirrored and all traffic going through that port can be duplicated and sent to a 2nd port. If i connect an SQL server to one port and another SQL server with identical databases to the other one, will this work as mirrored SQL servers. I would do this so that I have a standy server ready to take over the function of the primary server if it goes down.
Answers to "Can port mirroring be used to create a backup SQL Server"
RE: Can port mirroring be used to create a backup SQL Server?

Trust me, that is a REALLY bad idea. For one thing, you would have to write some middleware to decode the incoming TCP/IP traffic and feed that into whatever SQL server you are using.



and EVERY sql server out there I know does things like master/slave configuration, clustering and these things provide what you are after (a standy server ready to take over the function of the primary server), not some ugly net hack.



Use port mirroring for network monitoring (copy all traffic at your gateway to your IDS system, for instance).
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License