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