July 24, 2008 at 2:14 pm
I'm testing some stuff with database mirroring, and I ran into something that seems odd to me.
I got the mirror up and running (test environment), between two instances of SQL Server on my desktop machine. Failover worked just fine. Failover back to the original main database worked just fine. But when I turned mirroring off, the mirror database went into perpetual "Recovering..." mode.
The database is tiny. Takes less than a minute to restore from a backup file, but it sat there "Recovering..." for over an hour before I told it to delete the database (because I really didn't need it any more).
I tried this twice, with identical behavior both times, so it is repeatable, at least in this set-up.
Does anyone know if that's the usual behavior? I did a quick Google search on the subject, and found some similar things, but not this.
Since the mirror database is pretty much useless once mirroring is turned off, this isn't a problem, but it sure does seem odd.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 24, 2008 at 2:40 pm
By stopping mirroring, you ran:
ALTER DATABASE SET PARTNER OFF?
If that's the case, you have to manually recover it:
RESTORE DATABASE WITH RECOVERY.
The Redneck DBA
July 24, 2008 at 2:52 pm
The mirror's always in "recovering" state, waiting for more transactions. If you turn it off, it might be expecting that you'll turn it on, and I wouldn't want the SQL team to whack the database or bring it online automatically.
I think the proper response would be what you did if you didn't need it (drop it) or recover it if you did.
July 24, 2008 at 2:57 pm
Thanks for the replies. Just wanted to make sure I wasn't doing something wrong. (My first time playing around with mirroring.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply