I'm attempting to setup BES Database mirroring, but seem to be running into an issue. I'm following this KB:
I've gone through all of the steps, but when I recover the database on the standby server with the "NORECOVERY" option for both DB and transaction logs the database gets stuck at (Restoring...)
I can get mirroring up, but the secondary DB stays in the restoring state. I can't expand it as it returns an error stating the the DB is not accessible.
When I recover using "NORECOVERY" option for the DB but "RECOVERY" for the transactions log the DB gets created successfully but I can't enable mirring.
Any ideas? Are the the transaction logs supposed to be recovered with recovery option or without?
SQL 2008 R2