Viewing 15 posts - 4,186 through 4,200 (of 9,244 total)
Does the PK have a clustered index upon it at present?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 10:14 am
yes but i'm assuming you'll have other databases that are not part of the AO group or even other instances that may use DTC, if you don't then don't worry....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 5:35 am
SQLSACT (4/16/2013)
Because Node1 has SQL installed as nonclustered, is it safe to say that it's not absolutely necessay to share DTC across all 3 nodes.
yes you could argue that....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 4:59 am
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
Viewing 15 posts - 4,186 through 4,200 (of 9,244 total)