Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

BES5+ SQL DB Mirroring

Posted on 2011-03-21
1
Medium Priority
?
662 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:Inimical023
1 Comment
 
LVL 8

Accepted Solution

by:
dba2dba earned 2000 total points
ID: 35183263
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question