InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 04:53:48 GMT20http://www.sqlservercentral.com/Forums/Topic1065553-146-1.aspx[quote][b]Oliiii (2/17/2011)[/b][hr]Hot standby is a server that will automaticaly failover if the primary server fails. You can get this using synchronous mirroring + witness (not sure if a cluster can be called a hot standby).Warm standby is a server that will not automaticaly failover and that may not have all the latest transactions. You can get it by using log shipping or asynch mirroring.Cold standby is just a spare machine that needs to be turned on, backup restored (or even full staging of the machine).[/quote]I would call a cluster a "hot standby". Anything high availability model which "should" require no intervention in the event of failure would a hot standby.Mirroring with a witness is a hot standyby. Mirroring without a witness is a warm standby.Fri, 18 Feb 2011 02:51:14 GMTMysteryJimbohttp://www.sqlservercentral.com/Forums/Topic1065553-146-1.aspxThanks for you reply !!Regards,Ravichandra.Thu, 17 Feb 2011 23:29:27 GMTravisamigohttp://www.sqlservercentral.com/Forums/Topic1065553-146-1.aspxHot standby is a server that will automaticaly failover if the primary server fails. You can get this using synchronous mirroring + witness (not sure if a cluster can be called a hot standby).Warm standby is a server that will not automaticaly failover and that may not have all the latest transactions. You can get it by using log shipping or asynch mirroring.Cold standby is just a spare machine that needs to be turned on, backup restored (or even full staging of the machine).Thu, 17 Feb 2011 06:36:11 GMTOliiiihttp://www.sqlservercentral.com/Forums/Topic1065553-146-1.aspxDear All,Can someone clear out my doubts here?pleaseWhat is the meaning of Cold standby,Warm standby & Hot standby solutions ?NOTE:Please provide me the examples for each of one.Thanks in advance.Regards,Ravi.Thu, 17 Feb 2011 04:45:17 GMTravisamigo