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

Question
-
Hi,
I am having problems setting up database mirroring (SQL Server 2008).i stooped Mirroring then I restored My Primary Data base first , and then Mirror data base with same backup file . and i start the mirror but i am getting below error
the remote copy of database is not recovered far enough to enable database Mirroring
Please can someone help!
Thanks,
Gajanan
Answers
-
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
-
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
-
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
All replies
-
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
-
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
-
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