Recently I have started to implement database mirroring and faced with some trouble. According to Books online, full database backup and
T-Log backup must be restored in the mirror instance in
WITH NORECOVERY mode:
The mirror database must be in the RESTORING state for mirroring to work. When preparing a mirror database, you must use RESTORE WITH NORECOVERY for every restore operation. Minimally, you will need to restore WITH NORECOVERY a full backup of the principal database, followed by all subsequent log backups.
But when I start mirroring, I receive following exception:
"Database "MyDB" cannot be opened. It is on the middle of restore(Microsoft SQL Server, Error 927)
Can anyone explain, whether I misunderstood something ?