Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mattt
Posting Yak Master
194 Posts |
 Posted - 2012-07-30 : 05:07:31
|
| Hi,We recently had some issues with the failover on a mirrored database: the login kept failing when the primary was down.On connecting to the database in question with the the login that was failing (in order to check the password) I discovered the reason why. The failover database appeared to be stuck in the "restoring..." state rather than "mirror/synchronised / restoring" as expected.However I found this slightly peculiar because the primary server was reporting that mirroring was working correctly. On logging in to the failover DB using an administrative account, it's status reported correctly as "mirror/synchronised / restoring".I've never seen this before - that different accounts looking at the same database can report a different mirroring status. The lower-level access account we usually use behaves in all respects as though the failover DB is stuck in restoring - when you attempt to change permissions, for example, it reports that one of the DB's is inaccessible.What's caused this curious state of affairs, and how can I fix it?Cheers,Matt |
|
|
sql-lover
Yak Posting Veteran
99 Posts |
Posted - 2012-08-04 : 00:51:36
|
| Did you reset the SID on the other server after failover? I know, a silly question, but you need to ensure you reset the SID or the login won't work after the fail over, as the users are not the same for SQL.I would also check network latency between both servers and ensure they both are running same SQL version. You can visually check on Management Studio the status of both databases. I've never seen both on restoring phase unless there was a failover issue and it never happened. On that case, restore one with recovery, break the mirror and setup again. |
 |
|
|
|
|
|
Mirroring status different for different users