title: How intelligent is SQL Server Mirroring?
body: <p>While working on my current development product I have setup SQL server mirroring between the primary data center and the secondary data center.  In the primary data center the SQL .mdf and .ldf files are stored on the SAN.</p>
  
  <p>Now admittedly it should be very unlikely for us to lose the SAN but if for example the connection to the SAN was lost and the database integrity was lost.  Would the mirroring still happen?  I.e. would SQL now mirror the broken database and now both are equally broken?</p>
  
  <p>From googling its not clear when mirroring will and will not happen so I was hoping that the community may be able to share some of there experiences.</p>
  
  <p>I also have backup schedules setup which would be a final fail safe but realistically I would hope that the mirrored database would be our quickest way to bring everything back online.</p>
  
  <p>In this scenario at present there is no witness server in the mirroring process although with the benefits of automatic failover I am thinking of adding one.</p>
  
  <p>Thanks</p>