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 |
|
LeeButts
Starting Member
11 Posts |
 Posted - 2008-01-08 : 11:27:08
|
Hi guys i have set up 3 servers principal,mirrored and witness i took a backup of the principal database and recover it on the mirror server. for 30 minutes or so it said "Recovering..." next to the mirrored database and would not let me access it. Now it has changed to say "In recovery" it has been like this for a while too. Is this the natural recovery process? will it come back on line or do i have to do something to the database to make it usable.Many thanks in advanceLee |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 22:37:01
|
| You can't access mirrored db unless switch it to principal role. |
 |
|
|
LeeButts
Starting Member
11 Posts |
Posted - 2008-01-09 : 02:52:16
|
| it's not in a mirrored role yet. When i configure security for the mirroring works fine, but when i click the start mirroring button the following message appears:The server network address "joe bbloggs" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational SQL Serever error 1418Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 23:23:22
|
| It's different issue, ensure those servers can talk to each other. |
|
|
|
|
|
|
Restore to mirrored database