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" 😉