the remote copy of database is not recovered far enough to enable database mirroring in SQL 2008

Answers

• 

  

  0

  Sign in to vote

  you need to take transaction log backup from primary and restore it on mirror.

  • Proposed as answer by Michelle LiModerator Friday, March 27, 2015 1:12 PM
  • Marked as answer by Michelle LiModerator Wednesday, April 8, 2015 6:40 AM

  Friday, March 27, 2015 4:52 AM

  Reply

  |

  Quote
• 

  

  0

  Sign in to vote

  Because the full backup file that you restore on your mirror database is not new and fresh enough to catch the primary database. So, backup log from the primary database and restore(with norecovery) it on the mirror database in the possible shortest time and try starting the database mirroring.
  

  • Edited by dave_gona Friday, March 27, 2015 5:10 AM
  • Proposed as answer by Michelle LiModerator Friday, March 27, 2015 1:12 PM
  • Marked as answer by Michelle LiModerator Wednesday, April 8, 2015 6:40 AM

  Friday, March 27, 2015 5:03 AM

  Reply

  |

  Quote
• 

  

  0

  Sign in to vote

  You are doing wrong please refer to any document which would tell you how to proceed with database mirroring

  http://www.sqlservercentral.com/blogs/mssqlfun/2014/10/13/configure-sql-server-database-mirroring/

  Please take full backup from principal server and restore it on mirror and then take log backup and restore it on mirror. make sure you restore all log backups taken after full backup you restored otherwise mirror wont initialize

  ---

  Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
  
  My Technet Wiki Article
  MVP

  • Proposed as answer by Michelle LiModerator Friday, March 27, 2015 1:12 PM
  • Marked as answer by Michelle LiModerator Wednesday, April 8, 2015 6:40 AM

  Friday, March 27, 2015 5:09 AM

  Reply

  |

  Quote

  Moderator