I have 2 server in mirroing... this morning i have to boot the mirror server and whens its up the message in mirror database was "restoring..." only.Before the message was something like (restoring, synchronized..etc)..now only "restoring..." . In principal server the message is "principal, synchronized"..but will be synchronized really ?
When i configured this mirroring , this message in target server (only "restoring...") shows up when i restored the dabatase before starts synchronized doing de statments ALTER DATABASE XXX SET PARTNER in principal an target servers.
I try to do this statments agains and shows up a error message
Msg 1405, Level 16, State 4, Line 1
The database "SM" is already enabled for database mirroring.
Msg 1452, Level 16, State 6, Line 2
The partner server instance name must be distinct from the server instance that manages the database. The ALTER DATABASE SET PARTNER command failed.
This servers are really synchronized ?
$hell your Experience !!!