Viewing 15 posts - 4,306 through 4,320 (of 9,244 total)
Check the output of the following query for top consuming tables and post their names
USE msdb
GO
SELECTOBJECT_NAME(i.object_id) AS TableName
, ISNULL(i.name, 'HEAP') AS IndexName
, i.type_desc AS IndexType
, p.partition_number AS PartitionNo
, p.rows AS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 6:18 am
The issue only seems to be affecting local disks too, all my windows 2012\sql server 2012 VMs are on ESX5.1 and are using iSCSI disks not VMWare virtual disks. I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 6:13 am
kevaburg (2/12/2013)
Although this is a very good article with regards to moving user databases
That is exactly what it is targeted at!
kevaburg (2/12/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2013 at 8:47 am
where did you check the bindings?
double check the TCPIP settings for each NIC and report back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2013 at 4:37 am
sismb8 (2/12/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2013 at 3:40 am
Yulingxu (2/11/2013)
Thanks Perry for this article.I see MS SQL Server is more like Oracle Database to handle those physical files.
Thanks
Yuling
As a SQL Server\Oracle DBA i disagree. Oracle has no concept...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2013 at 3:39 am
SQL Pizza (2/11/2013)
Security Handshake failed to obtain SecurityContext for NetFT driver
You need to throw a dog a bone here my friend, what you've given is not very helpful. Can you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 8:25 am
which problem?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 7:27 am
Very little, you still have a clustered SQL Server service and a clustered sql server agent service. Now, if you're asking the differences between Windows 2003 clusters and Windows 2008...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 7:23 am
With that level of knowledge you're not leaving yourself much margin for error!
The first thing you will want to do is to check the current hardware against the Windows Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 6:33 am
Check network connectivity between the nodes and the domain.
Have you checked the windows event logs and also the cluster events for further info.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 5:53 am
Have you ever carried out an upgrade of this type before?
Do you plan to use a side by side upgrade or upgrade the existing system?
What SQL Server service pack level...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 5:45 am
have your server admins check that each node is well connected to the domain for starters.
Are these physical or virtual machines?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 5:43 am
Can you supply a little more detail about the environment and exactly what steps you are at when you get the failure?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 5:09 am
Willem Gossink (2/11/2013)
Your article suggests using the "ALTER DATABASE ... " T-SQL command to bring the database back online. This is, of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2013 at 4:34 am
Viewing 15 posts - 4,306 through 4,320 (of 9,244 total)