October 30, 2014 at 10:05 am
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
October 30, 2014 at 10:12 am
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" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply