Viewing 15 posts - 2,551 through 2,565 (of 9,244 total)
ideally reboot as soon as the patches are applied, holding off til the end of the day has never been too much of an issue for me though
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2014 at 12:19 pm
why have you configured the instance to use 1434, best practice would be to set a static high range port for the instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2014 at 12:17 pm
put the clustered DTC resources into the SQL server instances cluster role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2014 at 12:15 pm
full machine backup (system state and app drives)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2014 at 12:13 pm
SQLKnowItAll (12/30/2014)
All that being said, do you have any further thoughts?
Yes, if your cluster was a 3 node cluster you wouldnt need a disk based quorum, Majority Node Set would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 31, 2014 at 3:03 am
SQLKnowItAll (12/30/2014)
Also, all 4 nodes are part of the same WSFC. (also edited to make clearer)
ok, that wasn't clear before
SQLKnowItAll (12/30/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2014 at 5:50 am
matt.newman (12/12/2014)
The problem is here that I can't get this one, bigger, more transaction heavy DB to mirror. 27 other databases I can get, but this 1 single DB is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2014 at 2:44 am
SQLKnowItAll (12/29/2014)
Setup:
Hypervisor = VMWARE
OS = SQL 2012 R2
SQL = SQL Server 2012 Enterprise Ed. (of course)
SAN =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 30, 2014 at 2:37 am
1433 is the default port, do you havce TCP\IP enabled?
Have you installed a default or named instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2014 at 9:27 am
ramyours2003 (12/29/2014)
Thanks for the reply, apart of the dashboard is any DMV's to trouble the Always on
Yes, a shed load!!!
Really, a simple google search is all you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2014 at 9:25 am
The dashboard would be one way, have you looked at this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 29, 2014 at 4:52 am
saum70 (12/27/2014)
Previously we used to store sql user logins in registry or xml for our applications(made in C#) to access the database. Now we are proposing that the application be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 28, 2014 at 1:11 pm
nlion84DBA (12/26/2014)
1. Evict the standalone node
2. Install SQL Server
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 28, 2014 at 4:12 am
Firstly, are both files in the same filegroup??
sextonk (12/23/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 25, 2014 at 11:14 am
both replicas must be configured for synch mode and automatic failover, check the AO group properties
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 25, 2014 at 3:42 am
Viewing 15 posts - 2,551 through 2,565 (of 9,244 total)