SQL 2005 Mirroring

By patrickdelosreyes ·
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.
-->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)

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums