Viewing 15 posts - 4,261 through 4,275 (of 9,244 total)
If you're mirrirong between instances on the same server you cannot use the same port number, the port number must be different.
With regards to an endpoint it is instance wide...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2013 at 4:19 am
can you provide more info on the cluster disk setups please
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2013 at 4:15 am
You don't have to reboot there and then just defer it until you get the opportunity to reboot
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2013 at 4:05 pm
scogeb (3/1/2013)
You can also do server\instance,portlike
SQL01\TestInst,55001
You generally supply one or the other. Instance name or port number not both.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2013 at 2:19 pm
shannonjk (2/25/2013)
In 9 years I have not come across an issue where an application built on SQL, could not work if it was set on a named instance.
It's usually...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2013 at 1:17 am
TrailRunner (2/28/2013)
Just inherited a 3 node active active active SQL 2K8 R2 cluster. 6 RTM instances, 2 on each node. I am in need to patch SP2 on only...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2013 at 1:13 am
sej2008 (2/28/2013)
Will two mirroring sessions on same instance use single endpoint or I requiretwo separate endpoint for two mirroring session on my box.
The endpoint is instance wide so both will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2013 at 8:51 am
you need an endpoint on each instance in the mirror relationship, if they're on separate machines you can use the same port number.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2013 at 3:48 am
SQLSACT (2/26/2013)
So even if SQL is installed as non clustered, DTC can still become involved somehow
DTC is not just used for SQL Server, the OS uses it for remote calls...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2013 at 3:44 am
Koen Verbeeck (2/28/2013)
This certification doesn't really "expire".
Once the product reaches end of life it expires
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2013 at 3:37 am
akshay.pawar123 (2/27/2013)
Here's the catch - SQL Server would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2013 at 3:16 am
Vertigo44 (2/26/2013)
The production database has 1 MDF and 1 log file.The log file extension is idf instead of LDF. Would this cause issues?
You just need to change the name in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2013 at 5:27 am
The quorum is a single mediator, there is only 1. It can use a file share or disk but also can use neither depending on the cluster configuration.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2013 at 11:36 pm
Bert-701015 (2/26/2013)
but can a replica be clustered as well?
Yes that's what the article discusses 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2013 at 12:13 pm
Kaushal.M (2/26/2013)
Can a single computer be part of multiple clusters?
No, a computer can be a member of only one cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 26, 2013 at 3:47 am
Viewing 15 posts - 4,261 through 4,275 (of 9,244 total)