Viewing 15 posts - 1,186 through 1,200 (of 9,244 total)
VastSQL (8/2/2016)
Perry Whittle (8/2/2016)
Then you'll have a cluster with no failover capability!I'd still like to know the full spec of each VM (I.e. Number of vcpus, vnics, vdisks, etc)?
Thanks Perry.
As...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2016 at 2:03 pm
JP10 (8/3/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2016 at 1:59 pm
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2016 at 5:52 am
ODBC table links are created via linked table manager, google will detail exactly how to connect
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2016 at 5:51 am
mikaeru (8/1/2016)
I'm currently trying to set up Always on 2012 between 2 different data-center's using of course 2 different subnets, i have few questions;
Situation: we got 3 servers under...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2016 at 5:49 am
sql server 2005 and sql server 2016 have very different OS support, so they wont reside on the same server.
If you have a sql 2005 instance on one server and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2016 at 5:44 am
The passwords only need to be updated once and on the active node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2016 at 10:14 am
Also bear in mind, if the principal and mirror then become disconnected too, the principal will go offline.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2016 at 10:12 am
This is mainly used for internal operations and things like linked servers , etc.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2016 at 9:59 am
I have done in the past, if you're really uncomfortable get a maintenance window arranged
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2016 at 8:52 am
Run the drop server then add server they should run instantaneously
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2016 at 8:28 am
Then you'll have a cluster with no failover capability!
I'd still like to know the full spec of each VM (I.e. Number of vcpus, vnics, vdisks, etc)?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2016 at 8:17 am
krypto69 (8/2/2016)
Without the TF 1117 the splitting of the tempdb into multiple files is likely to be an utterly useless exercise as the load will more or less end up...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2016 at 8:13 am
ThomasRushton (8/2/2016)
Terje Hermanseter (8/2/2016)
To view only RESTORE/BACKUP operations you can include a where clause:
SELECT *
FROM sys.dm_exec_requests
WHERE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2016 at 8:06 am
GilaMonster (8/2/2016)
That's the account for machinename\local system, used if you have services running on that machine running as local system (which is not a good thing to do)
It's actually the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2016 at 8:00 am
Viewing 15 posts - 1,186 through 1,200 (of 9,244 total)