SQL 2008 Mirroring, in "restoring" state
I'm testing SQL Server 2008 mirroring with a principal, a mirror and a witness. I've gone through the [examples][1], restoring the mirror WITH NORECOVERY. The principal says it is synchronized. But the mirror still shows it is in a "restoring..." state. Am I supposed to just leave it like that? Should I run a RESTORE WITH RECOVERY?


  [1]: http://msdn.microsoft.com/en-us/library/ms189047.aspx
SQL 2008 Mirroring, in "restoring" state
===

I'm testing SQL Server 2008 mirroring with a principal, a mirror and a witness. I've gone through the [examples][1], restoring the mirror WITH NORECOVERY. The principal says it is synchronized. But the mirror still shows it is in a "restoring..." state. Am I supposed to just leave it like that? Should I run a RESTORE WITH RECOVERY?


  [1]: http://msdn.microsoft.com/en-us/library/ms189047.aspx