Viewing 15 posts - 2,341 through 2,355 (of 9,244 total)
after the recovery model switch you may run a differential backup and use this along with the existing full backup to initialise the new secondary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 9:36 am
not an error I've ever seen before.
Can you provide more detail on the cluster configuration, is this a new cluster or are you running the validation on an existing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2015 at 9:28 am
need to be looking in this catalog sys.dm_hadr_database_replica_states
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 21, 2015 at 7:31 am
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
Viewing 15 posts - 2,341 through 2,355 (of 9,244 total)