Posted by serge on 03/02/07 14:18

I have 2 SQL Enterprise Editions running SP2 and same collation.

When i try to start database mirroring I get the following error
message:

"The remote copy of database "ABC" has not been rolled forward
to a point in time that is emcompassed in the local copy of the
database log. (Microsoft SQL Server, Error: 1412)"

Both SQL Server services are running under account
Domainname\myusername.
On both servers SQL Logins I made Domainname\myusername
a member of sysadmin.

On the Principal server I created a database using FULL recovery
mode, made a backup and restored it on the mirror server using
WITH NORECOVERY.

On the Principal server, database properties, mirroring, configure
security goes fine (I am not choosing to setup a witness server for now)
but start database mirroring fails with the above error message.

On the mirrored server the "ABC" database in MS says
"ABC (Restoring...)"

BTW, how can I change my primary server from automatically picking
port 5023. Do I have to run T-SQL and delete an endpoint in order
for the next configuration i get back the default port 5022?

If this is not the correct newsgroup please let me know which
newsgroup I should post database mirroring questions.

I appreciate any help.

Thank you

[Back to original message]