Cluster SQL Server Agent

Todas as Respostas

• sexta-feira, 1 de junho de 2012 05:34

   

   
  

  2

  I do prefer to have a look at that Microsoft guide below for clustering sql server step by step  to guide you on the right way:

  http://social.technet.microsoft.com/Forums/en-US/sqldatabaseengine/threads

   

  ---

  Shehap (DB Consultant/DB Architect) Think More deeply of DB Stress Stabilities

  • Responder
  • Citação

   
• terça-feira, 5 de junho de 2012 09:14

  Moderador

   

   
  

  0

  Hi Kalyan,

  In a failover cluster configuration, this takes the full-text and SQL Server Agent resources offline; however, it does not bring the full-text or SQL Server Agent resources back online when SQL Server is restarted. You must restart those resources manually using the Windows Cluster Administrator utility.

  For more information please see:

  http://msdn.microsoft.com/en-us/library/ms175549(v=sql.105).aspx

  http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/5049fc44-0f44-4caf-9c5a-282edf30d878/

  ---

  Best Regards,
  Iric
  Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • Marcado como Resposta Iric WenModerator segunda-feira, 18 de junho de 2012 01:56
  •  
  • Responder
  • Citação

   
• terça-feira, 5 de junho de 2012 13:42

  Moderador

   

   
  

  0

  When you install SQL Server in a cluster environment, it installs SQL Agent in the same cluster group as the database engine.  When the cluster fails over, Agent fails over also.  Unless you change this behavior, you will always have Agent on the same server as the database engine.

  • Marcado como Resposta Iric WenModerator segunda-feira, 18 de junho de 2012 01:56
  •  
  • Responder
  • Citação

   
• sexta-feira, 8 de junho de 2012 03:45

   

   
  

  0

  Hello K.Kalyan,

  See links below

  Step By Step on Windows Cluster

  http://technet.microsoft.com/en-us/library/bb727114.aspx
  

  See this post with lots of links for Installing a SQL Server Cluster

  http://social.msdn.microsoft.com/Forums/br/sqldisasterrecovery/thread/5ddcde6f-345f-4926-999b-8da3d10b91df

  When you load SSIS packages you can choose to store them in a shared location or to save it in msdb. (http://msdn.microsoft.com/en-us/library/ms141235%28v=sql.105%29.aspx)If you save the SSIS packages in msdb, and you are using cluster you have to know the following

  -Integration Services are not clustered(as of 2008R2), hence if you have 2 nodes, you need to specify in which instance to store SSIS packages. You can configure this in MsDtsSrvr.xml. See how to do it in the next link

  http://msdn.microsoft.com/en-us/library/ms137789.aspx

  • Responder
  • Citação