Viewing 15 posts - 4,186 through 4,200 (of 9,241 total)
SQLSACT (4/16/2013)
By this do you mean it's not part of the storage allocated to the clustered instance of SQL Server?
Yep, MSDTC has absolutely nothing to do with SQL Server,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 3:31 am
SQLSACT (4/16/2013)
Nope - All Servers are in the same DC
DC?
SQLSACT (4/16/2013)
Would it make a difference if it was spanned across multiple sites?
It's a consideration, yes.
SQLSACT (4/16/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 2:51 am
SQLSACT (4/16/2013)
My Setup:
>> 3 Servers (Node1-Node2-Node3) all part of the same Cluster "Cluster1"
>> SQL installed as clustered on Node2 & Node3, producing "SQLCluster"
>> SQL installed as nonclustered on Node1,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 2:08 am
JayK (4/15/2013)
Thanks for getting back - in reality I just need to check that data in a single column is the same for each matching PK in the 2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 1:58 am
tsdsuresh (4/15/2013)
I have set up logshipping between server A (Primary) and server B (Secondary), and tested log shipping by activate database from server B ( Stop the log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 1:47 am
check results of the following query both before and after the drop
SELECTOBJECT_NAME(i.object_id) AS TableName
, ISNULL(i.name, 'HEAP') AS IndexName
, i.index_id as IndexID
, i.type_desc AS IndexType
, p.partition_number AS PartitionNo
, p.rows AS NumRows
,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 1:44 am
Interesting one this, there is a known issue around the removal of LOB data in sql server. Dropped LOB data is not removed immediately, there is a ghost process that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 12:25 am
A well formed Windows cluster is a pre requisite for a clustered sql server instance.
First you must cluster the Windows operating system on the computer nodes. Once this is done...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 12:18 am
In the folder
C:\Windows\System32\Drivers\etc
You'll find the HOSTS file here and also one titled SERVICES. Open the SERVICES file and it contains details of ports already assigned to services on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2013 at 3:10 pm
sql-lover (4/15/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2013 at 3:03 pm
ramyours2003 (4/15/2013)
What are the pre requisites to install cluster in sql 2008
Windows 2003 or Windows 2008?
Main pre reqs are
functional...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2013 at 5:58 am
pete_20 (4/14/2013)
We are running DBCC CHECKDB WITH ALL_ERRORMSGS.
After couple of minutes, the execution fails, sql service crashes and we get the following error:
Msg 64, Level 20, State 0, Line 0
A...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2013 at 5:56 am
are you saying you just want to check the data is identical for each row across all columns?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2013 at 5:41 am
You'll need to use aliases within the SQL Server configuration manager, these are detailed here.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2013 at 5:39 am
deep_kkumar (4/12/2013)
so that one instance running on node B and node c never fails over to node A.
Simple don't install the instance to NodeA 😉
If you do install the instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2013 at 11:53 am
Viewing 15 posts - 4,186 through 4,200 (of 9,241 total)