Database Changes in a 2 Node SQL Server Cluster

• RedCard

  SSC Enthusiast

  Points: 120

  More actions

  October 30, 2014 at 10:05 am

  #291994

  I have a two node SQL Server 2008R2 cluster. I need to create a table in and change a column in another table. Should I perform this activity on the active node or passive node first?

  Are there any "gotchas" I should be aware of before making these database changes? Any words of wisdom before I undertake this activity?

  Many thanks in advance.

  :g

• Perry Whittle

  SSC Guru

  Points: 234064

  More actions

  October 30, 2014 at 10:12 am

  #1755840

  RedCard (10/30/2014)

  ---

  I have a two node SQL Server 2008R2 cluster. I need to create a table in and change a column in another table. Should I perform this activity on the active node or passive node first?

  Are there any "gotchas" I should be aware of before making these database changes? Any words of wisdom before I undertake this activity?

  Many thanks in advance.

  :g

  The cluster is immaterial here. Any changes in a database on the sql server instance are written to the shared storage used by both nodes. Only one node owns the SQL Server resources at any time.

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"