Viewing 15 posts - 1,996 through 2,010 (of 9,241 total)
Joy Smith San (6/24/2015)
I installed two node sql server cluster annd during installation I configured for both IPV4 and IPV6.
I can see the below messages logged in sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 7:02 am
which versions of sql server are you moving between?
This is my script I use but wont work from sql2008 -> sql 2012 as the encryptor changed
SET NOCOUNT ON
SET CONCAT_NULL_YIELDS_NULL OFF
DECLARE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 5:59 am
Joy Smith San (6/25/2015)
Able to access SQL Server cluster with "virtual IP,1433" from a remote application server.
But it fails with the error "Server does not exist" when tried with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 25, 2015 at 5:52 am
alex_fajardo2002 (6/23/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 24, 2015 at 9:39 am
Joy Smith San (6/20/2015)
Joie Andrew (6/19/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 6:00 am
hari.devadas 4119 (6/18/2015)
Perry,We evicted Node 02 from the SQL 2008 Clusterand now on course for testing the P2V on Node 01 now.
Why on earth have you done that at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:58 am
where is the storage presented from?
have you checked the LUNs are properly exposed to both ESX hosts
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:48 am
charipg (6/17/2015)
restore is failing with below error.Msg 60004, Level 16, State 1, Line 0
Error starting process 'C:\Program Files\Quest Software\LiteSpeed\SQL Server\engine\SqlLiteSpeed.exe', Error: 0x3
not getting any idea.any suggestion pls.
Run a repair...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:45 am
dan-404057 (6/22/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:39 am
alex.sqldba (6/22/2015)
Read Only Routing URLS are configured as follows:Ireland\Primary tcp://Ireland.dom.local:49891ALL
Ireland\Secondary tcp://Ireland.dom.local:49841ALL
This is only a small part of the config required, please supply the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:09 am
there are cluster updates between 2012 and 2012 R2, if it's a cluster then definitely 2012 R2
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:04 am
either use failover cluster manager or the following PowerShell command
Get-ClusterResource | ?{$_.resourcetype -EQ "IP Address"} | ft OwnerNode,State,Name,OwnerGroup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 5:03 am
how are you uninstalling the node?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 10:06 am
SQL!$@w$0ME (6/18/2015)
Servers are on the same site. But the 3rd node will not be configured for high availability, just for reporting (no vote for quorum?)
If the servers are same site...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 10:05 am
Run this query on the primary, change the job name first, and post the output please
SELECT j.name
, jh.[step_id]
, jh.[step_name]
, jh.[message]
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2015 at 8:46 am
Viewing 15 posts - 1,996 through 2,010 (of 9,241 total)