April 20, 2014 at 10:38 am
Hi gurus
After rebooting the sql server 2008 R2 , I opened SSMS and found out that right beside my database name there is the following in () Mirror,synchronized/restoring..., I cant expand my DB to check tables and stuff.
Can someone help me out please, as you can see I am new to sql, so go easy on me.
Thanks a bunch gurus
April 20, 2014 at 11:42 am
The mirrored database is not available for reading. Anything you want to do, you will need to do on the principal database.
April 20, 2014 at 1:15 pm
Lynn
Thanks for jumping in, so how do I fix this issue?
Thanks a bunch
April 20, 2014 at 2:09 pm
Fix what, being able to open up the current database mirror? One, it isn't broken so nothing to fix. If you need to open it you either failover to the mirror making it the principal database and the current principal into the mirror or break the mirror and run possibly need to run backup database with recovery to make the database usable.
April 20, 2014 at 3:35 pm
guaro5555 (4/20/2014)
Thanks for jumping in, so how do I fix this issue?
You don't, there's nothing wrong.
The database is part of a Database Mirroring setup. It's a high availability feature where there are two databases in sync, one usable and one that's passive, waiting in case the principal fails. The database you're looking at is the mirror, it's supposed to be like that.
When you rebooted, the other database in the pair became the active one.
Speak to the DBA (or whoever set up the mirroring) and see whether they want to fail it back over or leave it like it is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply