How to remove SQL Mirroring from MOSS 2007

So mirroring technology with SharePoint 2007 does not seem to be working as expected. As a consequence, the decision to remove it from our production servers was made.

I have been trying to remove the mirroring from the SQL Serve 2008 R2, and it still shows the Mirror Databases on the secondary server.  Worse, the status does not change, it is still showing as (Restoring).

from the MSDN, this is supposed to be an easy step: ms189112 but it is not.!

As you can see, my SQL1 server has the actual databases, while SQL2 is supposed to have the mirrors of SQL1.

A quick search on the internet turned nothing to the (Restoring…) status message.  Connecting to the second SQL Server and trying to delete the database were encountered with failure.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Alter failed for Database 'SPSProd_Main_Search'.  (Microsoft.SqlServer.Smo)

For help, click: Some useless article on MSDN

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

ALTER DATABASE is not permitted while a database is in the Restoring state.
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 5052)

  Then I went into the query editor and ran the

DROP DATABASE <databasename> from the master databases. It worked.!

Command(s) completed successfully.!  :)

Installing SQL Server 2008 x64

If you want to have the DAT and LOG files on a separate drive, perform the standard setup and choose the default values.

On the feature selection window, make your selection and DO NOT CHANGE the location where your shared features will be.

If you do so, you will get this error message, and WILL have to restart the installation all over.

The INSTANCESHAREDWOWDIR command line value was not specified. This value must be specified when the INSTANCESHAREDDIR value is specified.

Read about it from the msdn knowledge base 955458.

Funny, it complaints about INSTANCESHAREDDIR when it is really looking for the WOW64 shared components directory INSTALLSHAREDWOWDIR.

Check the Configuration file path at the Ready To Install screen:

If you open this ConfigurationFile.ini you will see the entries what the boot strapper is looking for.

Continuing with the default installation, you will get to the Database Engine Configuration screen, that’s is where you can specify the location for the DAT and LOG files.

Non-intuitive, IMHO.