I have a problem with database mirroring. There are two servers one PrimaryServer1, and FailoverSever1. I am able to configure the mirroring successfully. There is one table with some data. While application is running this table is being updated. I am able to see the updates in that table; suddenly I observed the updated data is erased, after some time I found that the Failoverserver1 system dates time is more than 12 hours compare to PrimaryServer1.
Here I have two questions
1. Because of date issue, that data is vanished?
2. After removing the Mirroring also, I am able to see the same behavior in PrimaryServer1.
Still I am unable to identify the issue, can anybody the help me out to resolve this issue.
Environment: Windows Server 2008 and Sql Server 2008 R2.