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.
