SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

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

imughal
Posting Yak Master

184 Posts
Posted - 11/27/2012 :  06:14:48  Show Profile  Reply with Quote
Hi,

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 : http://www.sharepoint.bg/radi/post/Step-by-Step-Guide-to-Configuring-Database-Mirroring-in-SharePoint-2010.aspx

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

chadmat
The Chadinator

USA
1949 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.

-Chad
Go to Top of Page

prett
Posting Yak Master

USA
161 Posts
Posted - 11/27/2012 :  22:33:42  Show Profile  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  
 New 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.03 seconds. Powered By: Snitz Forums 2000