Sql server 2008 database mirroring manual failover

In case your mirroring has been suspended and you have tried everything else and nothing works. Your last option is to break the mirroring and restore the mirror database and connect the client application to the mirror site. Before proceeding with this please note that doing this will require you to rebuild the Data Mirroring … Continue reading Sql server 2008 database mirroring manual failover

Advertisements

Change Modes Database Mirroring SQL Server 2008

Incase you want to change the mode of the mirroring from High Performance to High Safety. You can do it from the command line. ALTER DATABASE SET PARTNER SAFETY OFF; Please note that SQL Server 2008 Standard Edition does not allow changing the safety level. It will throw the below error "Msg 1473, Level 16, … Continue reading Change Modes Database Mirroring SQL Server 2008