Viewing 15 posts - 2,251 through 2,265 (of 9,244 total)
I have not covered backups in detail as there will be varying preferences involved. I may do something post the stairway series.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 25, 2015 at 9:21 am
The Redneck DBA (3/23/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 11:39 am
back them out then via add\remove programs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 11:32 am
Your current setup is not clear and you seem to be making incorrect use of the terminology.
Pablo Campanini-336244 (3/23/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 11:31 am
what makes you think you need to stop data movement or remove a database from an AG when applying Windows patches??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 11:22 am
you just switch the roles back.
Could you detail exactly what you did to switch the primary role from server A to server B?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 8:34 am
so what patches were applied since the date you have identified?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 8:32 am
why do you need to remove the database from the AG?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 8:28 am
why don't you configure a listener for the availability group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2015 at 8:23 am
Well firstly, the message you posted originally details the issue, you're facing memory pressure within the instance. This is confirmed by the fact you have 80GB RAM free on node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2015 at 5:34 pm
so node b and node c both have 128GB RAM and the 4 instances on node b have max memory set to 12GB?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2015 at 2:40 pm
check your server logs for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2015 at 11:11 am
How much physical RAM does NodeC have, what is the total of Max mem assigned to the 4 instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2015 at 11:10 am
can you provide more info on how this user maps into the database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 11:30 am
granting execute at schema level is the only other way but it OTP in this case by the sound of it.
The object grants you are currently performing are the only...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2015 at 10:56 am
Viewing 15 posts - 2,251 through 2,265 (of 9,244 total)