Sql-server – SQL Server 2008 Mirroring

mirroringsql serversql-server-2008

How would one start the secondary mirror instance if the principal SQL server instance went off line?

Best Answer

I'm assuming you don't have automatic failover and no witness, otherwise the mirror would have been promoted automatically.

In this case you need to switch the roles manually, with forced service:

ALTER DATABASE database_name SET PARTNER FORCE_SERVICE_DATA_LOSS

See Role Switching During a Database Mirroring Session
and ALTER DATABASE Database Mirroring for more detail.

Related Solutions

SQL Server 2008 – Database Mirroring with TDE

Found a website with a comment on it.

I added the code to just after where I restore the key and cert

--Mumbojumbo to get mirroring to work
OPEN MASTER KEY DECRYPTION BY PASSWORD = '1Password'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
GO

It works like a charm, it makes a little sense that I had to encrypt the master key that I restored with the service master key of the new server. I guess.

shrug

SQL Server 2008R2 – Why Databases Are Not Mirroring

After all that one of the servers didn't have the SQL Server service running under the same user. I'm an idiot.

Best Answer

Related Solutions

SQL Server 2008 – Database Mirroring with TDE

SQL Server 2008R2 – Why Databases Are Not Mirroring

Related Question