Inimical023
asked on
BES5+ SQL DB Mirroring
Hi,
I'm attempting to setup BES Database mirroring, but seem to be running into an issue. I'm following this KB:
http://www.blackberry.com/btsc/dynamickc.do?externalId=KB21884&sliceID=1&command=show&forward=nonthreadedKC&kcId=KB21884
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?
BES 5.0.2
SQL 2008 R2
Thanks.
I'm attempting to setup BES Database mirroring, but seem to be running into an issue. I'm following this KB:
http://www.blackberry.com/btsc/dynamickc.do?externalId=KB21884&sliceID=1&command=show&forward=nonthreadedKC&kcId=KB21884
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?
BES 5.0.2
SQL 2008 R2
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.