[Troubleshooting] The remote copy of database XX has not been rolled forward

Steps:

1. Backup database testmirror on Pricipal server

2. Backup database log of testmirror on pricipal server

3. Copy db and log backup files to Mirror server

4. Restore DB WITH NORECOVERY

5. Restore LOG WITH NORECOVERY

6. Create endpoints on both pricipal serverand Mirror server

Issue:

If you use SQL command or Mirror the wizard to set Mirror.

It'll show Error: "The remote copy of database" Dbmirrortest "has not been rolled forward to a point in time that's enc Ompassed in the local copy of the database log. "

Or

1. ALTERDATABASETESTBACKUP01SETPARTNER=' tcp://isrv04.xxx:50221 ';

2. Tasks, Mirror->mirroring, Config Security

Solutions:

RESTORE DATABASE  from DISK  with FILE = 1, NORECOVERY, nounload; RESTORE LOG  from DISK  with FILE = 2, NORECOVERY, nounload;

These did the trick for me. I generated the commands through the "Script"-menu within the "Restore Database"-dialog of the Management Studio, because Enabling mirroring is no problem when I restored through the "Restore Database"-dialog. My manually written sql-commands were missing the "Nounload" part.

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

[Troubleshooting] The remote copy of database XX has not been rolled forward