dbTalk Databases Forums  

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

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss SP2 Database Mirroring - "The remote copy of database "ABC" has not been rolled forward..." in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
serge
 
Posts: n/a

Default SP2 Database Mirroring - "The remote copy of database "ABC" has not been rolled forward..." - 03-02-2007 , 08:18 AM






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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.