Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 SharePoint_Config DB mirror error
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

192 Posts

Posted - 11/27/2012 :  06:14:48  Show Profile  Reply with Quote

i am configuring SharePoint_Config database mirroring. I have done following steps:

Primary Server:

Take full database backup
Take full transaction log backup

Mirror Server
Restore full database backup
Restore full transaction log backup

Refer this post :

restore successful when configure database mirroring getting following error :

The remote copy of database "SharePoint_Config" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (.Net SqlClient Data Provider)

Pls tell what is the issue.

Other content database mirror successfully. Pls guide. thanks

The Chadinator

1974 Posts

Posted - 11/27/2012 :  12:58:25  Show Profile  Visit chadmat's Homepage  Reply with Quote
Sounds like your Primary log was either backed up or cleared in some way after the log backup that you restored on the mirror.

Go to Top of Page

Posting Yak Master

212 Posts

Posted - 11/27/2012 :  22:33:42  Show Profile  Visit prett's Homepage  Reply with Quote
This error can occur in case only the full database backup has been restored on the mirror. To resolve this issue, restore the full database backup followed by transaction log backup with no recovery. Since IDW15, it is nor enough to just restore the full database backup. It is mandatory to backup and restore the transaction log before setting up mirroring. This was enforced to make sure that there is no break in the log chain on the mirror side.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000