Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2012-11-27 : 06:14:48
|
| Hi,i am configuring SharePoint_Config database mirroring. I have done following steps:Primary Server:Take full database backupTake full transaction log backupMirror ServerRestore full database backup Restore full transaction log backupRefer this post : http://www.sharepoint.bg/radi/post/Step-by-Step-Guide-to-Configuring-Database-Mirroring-in-SharePoint-2010.aspxrestore 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
1974 Posts |
Posted - 2012-11-27 : 12:58:25
|
| 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 |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-11-27 : 22:33:42
|
| 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. |
|
|
|
|
|
|
SharePoint_Config DB mirror error