471,093 Members | 1,998 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,093 software developers and data experts.

SP2 Database Mirroring - "The remote copy of database "ABC" has not been rolled forward..."

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

Mar 2 '07 #1
0 4182

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Mike Dickens | last post: by
3 posts views Thread by DB2 Convert | last post: by
6 posts views Thread by Dick Watson | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.