October 8, 2015 at 12:33 pm
Hi all,
i am pallning to apply sql 2008 r2 sp3 on cluster with mirror environment. please let me know how to do that .
environment is 2 node and 4 node cluster . mirroring was configured in the instances .
October 8, 2015 at 2:06 pm
Lavanyasri (10/8/2015)
Hi all,i am pallning to apply sql 2008 r2 sp3 on cluster with mirror environment. please let me know how to do that .
environment is 2 node and 4 node cluster . mirroring was configured in the instances .
Did you even try? A simple search on your favorite search engine will provide links to articles that explain how to do this in great detail. Far better than you will get from a forum post.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 9, 2015 at 8:09 am
Lavanyasri (10/8/2015)
Hi all,i am pallning to apply sql 2008 r2 sp3 on cluster with mirror environment. please let me know how to do that .
environment is 2 node and 4 node cluster . mirroring was configured in the instances .
Are the mirrored instances in 2 separate clusters?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2015 at 11:14 am
mirror servers : principal one cluster and mirror on another cluster . each cluster having 2 nodes .
after installation i got the below error
Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Exit code (Decimal): -2068578304
Exit facility code: 1204
The SQL Server failover cluster instance was not correctly detected. The instance was discovered on the local node but it was not found to be active. To continue, confirm the state of the instance installed on all applicable nodes of the cluster and the state of the failover cluster resources.
October 12, 2015 at 1:47 pm
you should be patching the mirror instance first, then failover to the mirror which now becomes principal.
Patch the instance that is now the mirror and then failback if desired
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2015 at 5:41 am
in cluster environment is it mandatory to failover the mirror .??
October 13, 2015 at 9:33 am
the clusters have no bearing here, they're merely providing resilience for each of the mirror instances at the instance level. Treat the 2 instances as exactly that, 2 sql server instances, just so happens they're clustered
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2015 at 12:14 pm
i have few servers without mirroring .. but still i am getting the same issue ...mentioned in the first ...
October 16, 2015 at 4:37 am
your original post mentions youre planning to apply a service pack!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply