Viewing 15 posts - 4,681 through 4,695 (of 9,241 total)
runal_jagtap (11/1/2012)
thank you everyone for quick response n help 🙂
I will like to add one more thing
We have one Rack Space server & other...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2012 at 4:18 am
runal_jagtap (11/1/2012)
coz if DB wont start how to check Error logs then??
More over coming...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2012 at 3:47 am
can you supply the results of this query please against primary and secondaries
selectar.replica_server_name
, ar.endpoint_url
, ar.replica_server_name
, ar.availability_mode_desc
, ar.failover_mode_desc
, ar.session_timeout
, ar.primary_role_allow_connections_desc
, ar.secondary_role_allow_connections_desc
, ar.backup_priority
, ar2.read_only_routing_url
from sys.availability_replicas ar
inner join sys.availability_read_only_routing_lists avr
on ar.replica_id =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 9:21 am
you're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 8:37 am
check your event logs for more info, there'll be some errors there that will be relative.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 4:52 am
normally stopping and restarting the endpoints will cure the issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 4:19 am
SQLSACT (10/31/2012)
Perry Whittle (10/31/2012)
SQLSACT (10/31/2012)
Please help me understand something the Cluster Quorum and specifically Node and Disk Majority
I understand that if you have an even amount on nodes on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 4:09 am
scogeb (10/30/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 2:51 am
SQLSACT (10/31/2012)
Please help me understand something the Cluster Quorum and specifically Node and Disk Majority
I understand that if you have an even amount on nodes on your cluster, it's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 2:47 am
raheelr 63130 (10/29/2012)
I think sql 2012 provides redundancy at DB level as well?
SQL Server 2012 also supports database mirroring although this feature is now deprecated and marked for removal in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2012 at 2:40 am
you asked why you were getting the error, i told you 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2012 at 4:05 pm
check the windows application log for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2012 at 8:50 am
yes, mirror is switched off when indicated to do so under SQL Server 2008 but the mirror partner thinks that the mirror relationship is still in place under 2012
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2012 at 8:45 am
raheelr 63130 (10/28/2012)
Hi Techs, is it possible to have DB level clustering in sql 2008? if so how can we achieve this?I know DB levek mirroring does work.
Regards
Raheel
Database mirroring offers...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2012 at 6:49 am
guerillaunit (10/28/2012)
DECLARE @MYHEX AS VARCHAR(MAX)
SET @MYHEX = '0000C180880810010000'
SELECT CONVERT(VARBINARY(MAX), @MYHEX, 1)
I get this error...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2012 at 4:23 pm
Viewing 15 posts - 4,681 through 4,695 (of 9,241 total)