Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 5 down vote favorite

I have a reindexing plan failing with error message: 

Refresh failed for PhysicalPartition '1'

(Details: SQL Server Enterprise edition running in cluster)

Searching through BOl and other online resources gave no pointers at all. What could this be related to?

share|improve this question
3  
What do you mean by reindexing plan? A SQL Server maintenance plan? SELECT * FROM sys.messages where text like '%Refresh failed%' doesn't return any results for me so not sure that error actually comes directly from SQL Server. Maybe you could try tracing the queries and error messages for the plan to see what exactly is failing. – Martin Smith Feb 17 at 13:06
@MartinSmith, thank you. Yes it is a server maintenance plan. Any handy pointers on how to setup a trace on a maintenance plan. – Unreason Mar 6 at 14:42

1 Answer

up vote -1 down vote

It appears that the issue occurs on the cluster node where the physical disk resource did not come online.

@Unreason: Before this problem started did u install any security update for Symantec Endpoint Protection.

  1. Check the events are logged in the Windows Server
  2. Check the Cluster log.

If you figure out it is because of the Symantec update. The Solution is

Solution

Symantec has released a product to resolve this issue. The fix has been included in Symantec Endpoint Protection 11 RU6.

Note: SEP 11 RU5 was the first client with official support for Windows 2008 R2. Migrate up to SEP 11 RU6 to resolve this issue, or downgrade to SEP11 MR4 MP2 if your policies require you to test with the newly released support products before introducing them in your production environment. SEP11 MR4 MP2 can be installed to Sever 2008 R2, but you first must install Liveupdate (lusetup.exe), and then install the MR4 MP2 client.

References Location to download Microsoft Handle tool - http://download.sysinternals.com/Files/Handle.zip

share|improve this answer
2  
The Solution is what? I suggest you complete the sentence. Links can die or change content and we encourage complete answers here, not links only. – ypercube May 20 at 11:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.