February 2, 2010 at 8:12 pm
I'm working on a database mirroring solution for Sharepoint 2007. I'm actually looking over this case study http://go.microsoft.com/fwlink/?LinkID=117905&clcid=0x409. On page 10 of this document it states in the Disaster recovery test section that a single database was forced offline. So I would like to ask how do you force a single database offline that is part of a mirroring sessions. If you run alter database {DATABASE name} set offline you will recieve the below error.
The operation cannot be performed on database "testmove" because it is involved in a database mirroring session.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
February 3, 2010 at 9:37 am
Hi,
You cannot take a mirrored database offline, even when the session is paused. Maybe it is suggesting to manually failover 1 database on 7. The WMI-based alert then detects a move on DATABASE_MIRRORING_STATE_CHANGE, and triggers the job to failover the other databases, provided that you have already implemented the alert and the job pages 6/7.
HTH
David B.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply