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 |
|
hdv212
Posting Yak Master
140 Posts |
 Posted - 2007-11-30 : 08:17:41
|
| Hi,I am having problems setting up database mirroring (SQL Server 2005).I made a backup of my database and transaction log, I restore this onmy Mirror server. I established the end points and I set the partneron my mirror server, I then received the error "The remote copy ofdatabase "DBNAME" is not recovered far enough to enable databasemirroring". when attempting to set the partner on my primary server.The database status on the mirror is "RESTORING".Please can someone help!Thanks, |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-30 : 10:10:59
|
This means the restore is not complete, you need to redo the restore on the the one that says "RESTORING" and make sure it completes.
Future guru in the making. |
 |
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2007-11-30 : 13:36:16
|
| thanks.but i restored mirror database completely(full backup and log backup that i created from main database in main server) in NoRecovery mode, and show me messageBox that Restore successFully completed. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-30 : 14:14:29
|
If you are in SSMS does the database have the word "Restoring" in parenthesis next to it? This indicates the database was restored with no recovery in which case it is waiting for you to restore some more files.
Future guru in the making. |
|
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2007-11-30 : 14:18:23
|
| thanksin mirroring, how to restore my database correctly (which options)? and can u say me true way ?regards |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-30 : 14:51:56
|
quote:
Originally posted by hdv212
thanksin mirroring, how to restore my database correctly (which options)? and can u say me true way ?regards
I don't have experience in mirroring but from my notes on it I see that the principal has to be in full recovery mode and when you do the initialization on the mirror you need to set it to no recovery as you did and then the next step is to restore the logs from the principal. Have you done that step?
Future guru in the making. |
|
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2007-11-30 : 15:51:06
|
| yes i done. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 01:15:29
|
| Run 'restore database db_name with recovery' then try again. |
|
|
|
|
|
|
The remote copy of database is not recovered ...