Wednesday, February 2, 2011

The Remote Copy Of Database Has Not Been Rolled Forward To A Point In Time That Is Encompassed In The Local Copy


I set up DB mirror between a primary (SQL1)  and a mirror (SQL2); no witness.  I have a problem when I issue command:


alter database DBmirrorTest

Set Partner = N'TCP://SQL2.mycom.com:5022';
go


The error message is:


The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy of the database log.


I have the steps below prior to the command. (Note that both servers' service accounts use the same domain account.  The domain account I login to do db mirror setup is a member of the local admin group.)


1. backup database DBmirrorTest on SQL1


2. backup database log


3. copy db and log backup files to SQL2


4. restore db with norecovery


5. restore log with norecovery


6. create endpoints on both SQL1 and SQL2


CREATE ENDPOINT [Mirroring]


STATE=STARTED


AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)


FOR DATA_MIRRORING (ROLE = PARTNER)


7. enable mirror on mirror server SQL2


:connect SQL2


alter database DBmirrorTest


Set Partner = N'TCP://SQL1.mycom.com:5022';


go


8. Enable mirror on primary server SQL1


:connect SQL1


alter database DBmirrorTest


Set Partner = N'TCP://SQL2.mycom.com:5022';


go


This is where I got the error. 


The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy


No comments:

Post a Comment