SQL 08 mirror menu option missing
Posted on 2009-07-09
I have, in the last few months, migrated my sql 05 data to a new server using Windows Server 2008 64bit SP1 and MSSQL 2008 SP1. This server is to be the principal on mirror setup. Last week on a different box I reloaded a 32bit version of Windows Server 2008 and MSSQL 2008 SP1. This 32 bit machine is to be the mirror.
On the mirror box, I am able to access the mirror menu option via right click/tasks/mirror or simply looking at the DB properties (any DB). On the principal box - I can't access the mirror menu option either way (any DB).
Additionally, when I add the SQL install disk (the same dvd used for both installs), the features menu for the mirror box includes 2 items (already installed) that don't list on the principal box: Analysis Services and Integration Services. BIDS is listed as installed on both boxes.
Hopefully I have included enough info for this to be clear to someone, as it is mud to me.