I have been having issues with our mirroring to Michigan. basically we have 3 servers.
Master in LA
Witness in LA
Mirror in Michigan
Basically the smaller database works fine.
My question is i tried to mirror a 4GB size database and it gives me an error.
So I think what is happening is it takes 3 hours to restore the database. So when i start the mirroring after restoring the database it thinks that the copy of the databse i have in the mirrored server is old… can anyone give me enlightenment.
An error occured while starting mirroring.
Additional information
–> Alter failed for DATABASE ‘KCF’. (Microsoft.SqlServer.Smo)
–>An exception occured while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConncetionInfo)
–>The remote copy of database “KCF” has not been rolled forward to a point in time that is encompassed in the local copy of the databse log. (Microsoft SQL Server, Error: 1412)
