i'm doing some tests to build one database with one mirror database and one witness.
so far, i'm failing in the first test, I want to kill the witness, then the Main database, and then put the Mirror database working as Main database.
So when I killed the witness,and then the Main database and did
ALTER DATABASE [MyDataBase] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
but i got:
Msg 1455, Level 16, State 106, Line 1 The database mirroring service cannot be forced for database "MyDataBase" because the database is not in the correct state to become the principal database.
i've been watching this tutorial http://www.youtube.com/watch?v=f67gfslkQew and in that video everything goes just has planed.
you can see here my databases and my query http://i42.tinypic.com/vp8chh.png to see if i'm missing something.
I'm having the same problem with both principal and mirror up, i'm unable to force mirror to turn to principal.
what am I missing?
edit: I can put the mirror database up with these commands
ALTER DATABASE [MyDatabase] SET PARTNER OFF RESTORE DATABASE [MyDatabase] WITH RECOVERY
but if I do this I loose my mirroring settings, and when the other database comes up, is not connected to this one.