Viewing 15 posts - 2,341 through 2,355 (of 9,241 total)
its the combination of the IP and port that should be unique.
You can listen on the same port as long as its on separate IP addresses
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2015 at 2:25 pm
curious_sqldba (2/19/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2015 at 2:23 pm
cmoy (2/19/2015)
no, I don't have a partitioned table. Just one table on a separate partition.
by partition you mean a windows logical disk??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2015 at 1:38 pm
have you checked the hotfix log for further details of the issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2015 at 1:35 pm
NJDave (2/12/2015)
HelloIn SQL 2005 Standard, SP 4 was installed on the passive node of a cluster first. SP4 should have been installed on the active node first.
Ideal that the SP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2015 at 1:33 pm
so its not clear, do you have a partitioned table?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2015 at 1:27 pm
daniarchitect (2/19/2015)
Select @@Servername is showing 'GEBPC\GEBPC'
where as the default sql instance shows 'GEBPC'
how can this happen?
please add your best intelligent guess here.
this created an issue while creating a linked server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2015 at 1:23 pm
nice article Steve, but would be helpful for readers to see the T-SQL behind the backup and restore commands I think
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2015 at 10:18 am
Cant remember exactly which catalog its in i'll dig it out and post it back.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2015 at 12:25 am
was the cluster validation report clean??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2015 at 8:09 am
my temptation here would be to just reinitialise the LS plan once I've confirmed the Primary is healthy
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2015 at 4:39 am
APA0876 (2/16/2015)
Hi I don't think this goes beyond a forum Post: the scenario is well defined -
Despite what you may believe, this is well beyond a forum thread. Have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 17, 2015 at 3:36 am
If you absolutely have to do something meantime, implement a basic LS plan in the interim until your AO config goes live and then remove the LS plan once AO...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2015 at 2:27 pm
not there already but imminent i think.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2015 at 2:21 pm
Ozzmodiar (2/16/2015)
It's been a long while since I've used log shipping to be honest; I wasn't aware that it was a 2-way process.
It isnt as such. You can role reverse...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2015 at 1:20 pm
Viewing 15 posts - 2,341 through 2,355 (of 9,241 total)