Skip to main content

Posts

Showing posts from September, 2012

Automatic Database Failover

 Problem A client called wanting to find why a database had failed-over to the DR server( this environment was configured mirror few OLTP databases) ; I was caught off guard, but gave him the usual reasons and wanted to have look at the server to be precise. But then to my amazement the client mentioned only one databases had failed over and the other databases were sitting on the primary server. What I did 1.)     Investigate the SQL Server errorlog 2.)     Investigate the Windows errorlog Steps ·          Found the time the failover happened from the sql Log Execute the following statement on the sql server instance Sp_Readerrorlog 0,1,’Fileover’; for more information of the Sp_ReadErrorlog function http://www.mssqltips.com/sqlservertip/1476/reading-the-sql-server-log-files-using-tsql/ ·          Now that I found the time window of the failure , I reviewed the events leading to the failover  As observed, the database mirroring for one databa