Viewing 15 posts - 3,091 through 3,105 (of 9,241 total)
DBA From The Cold (8/8/2014)
I'm setting a new SQL Server 2012 two node cluster and have a quick question about the virtual IPs of for both the cluster and SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2014 at 7:06 am
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2014 at 4:37 am
sp_configure is showing the raw bitmap value based on the CPU numbers, they are as follows
exec sp_configure 'affinity mask'
CPU number 7 ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2014 at 4:26 am
Firstly, have a look at this.
http://msdn.microsoft.com/en-gb/library/ff878716.aspx
Libby1981 (8/7/2014)
The third node dbprod1c will be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2014 at 4:02 am
This hasn't worked successfully for you, work through the guide again on a new database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2014 at 1:28 am
OK as long as you're aware
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2014 at 12:09 am
Just be aware of the overhead for CPU
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2014 at 2:43 pm
why on earth would you want to blanket deploy TDE???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2014 at 7:07 am
friedrichsenm (8/6/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2014 at 3:09 am
vkundar (8/6/2014)
I have to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2014 at 3:02 am
If you plan a failover, always stop your application services first. Why intentionally rip the database from under the app when you could have a clean shutdown and startup. The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 7, 2014 at 2:58 am
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2014 at 3:10 pm
Protect the cert by backing it up and securely storing the keys. Restoring master across servers has its own ramifications, so don't do it!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2014 at 12:00 pm
EdVassie (8/6/2014)
MSDTC no longer needs to be clustered or even active during the SQL install
Although if you don't have one clustered the installer stills bitches and moans and produces a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2014 at 9:07 am
vsamantha35 (8/5/2014)
Thanks Perry. Again, what is split brain? I have read that whenever private/heartbeat network fails, split brain occurs?
It happens less and less with the latest versions of Windows...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2014 at 5:26 am
Viewing 15 posts - 3,091 through 3,105 (of 9,241 total)