Solved

BES5+ SQL DB Mirroring

Posted on 2011-03-21
1
649 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 500 total points
ID: 35183263
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now