[TroubleShooting] The remote copy of database xx has not been rolled forward to a point in time

Source: Internet
Author: User

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 wizard to set mirror machine.

It will show error: "The remote copy of database" db1_test "has not been rolled forward to a point in time that is encompassed in the local copy of the database log ."

Or

1. ALTERDATABASETestBackup01SETPARTNER = 'tcp: // isrv04.xxx: 8080 ';

2. Tasks-> Mirror-> processing ing-> Config Security

 

Solutions:

RESTORE DATABASE @dbname FROM DISK = @backupfile WITH FILE = 1, NORECOVERY, NOUNLOAD;RESTORE LOG @dbname FROM DISK = @backupfile 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 indexing ing was no problem when I restored through the "Restore Database"-dialog. my manually written SQL-commands were missing the "NOUNLOAD" part.

 

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.