When you have SQL Server mirroring set up, do you trust that your mirror database will stay the same as the primary, even after months and months of mirroring? I know we all check the status, and of course it says the database is synchronized... but I worry that somehow the mirror might fall out of sync due to network glitches, software bugs etc. and the fault won't be detected. Then one day we need the mirror and we're horrified to learn that it's corrupted.
One thing I could do is periodically refresh the mirror from the primary, since our database is not terribly large. But perhaps I'm being overly paranoid.
I would like to hear from DBAs, either of SQL Server or any other platform, as to whether you share this concern about the integrity of mirror DBs, and if so, what you do to mitigate that concern. Do you occasionally re-copy your primary DB over to the mirror? Do you take other measures to ensure consistency between the two? Thanks for any advice you can provide.