Viewing 15 posts - 4,261 through 4,275 (of 9,241 total)
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
Rade_ (2/21/2013)
USE DATABASE
GO
select'CREATE LOGIN ' + sl.name +
' WITH PASSWORD = ' +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2013 at 5:13 am
it doesnt matter, 2nd approach is probably easier and would be the way i would do it.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2013 at 5:11 am
have you tried the Redgate forums or just raise a support call and ask the Redgate support desk, they're very helpful
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 21, 2013 at 8:16 am
Viewing 15 posts - 4,261 through 4,275 (of 9,241 total)