Link to home
Start Free TrialLog in
Avatar of skbarnard
skbarnard

asked on

SQL 2008 Cluster Sharepoint backend

We have a SQL 2008 cluster that appears to be broken.  There is a virtual instance (vsqlspntdb1) and 2 physcial nodes (sqlspnt01, sqlspnt02) Sqlspnt02 is the "owner" of the cluster but it should be the vsqlspntdb1.  
When I right click on a node, I don't see any option to move the resource to another node.  I'm unable to create a new maintenance plan or modify an existing plan - BUT the existing maintenance plan appeared to have run.  Haven't been able to verify because I can't remember where we're backing up to and I can't open the maintenance plan to verify/modify it.
Avatar of rocky_lotus_newbie
rocky_lotus_newbie
Flag of India image

Are you able to connect to the SQL Server Instance from management studio?

What is the errors you see when you mentioned - the sql cluster appears broken and unable to edit maintenance plan?

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of skbarnard
skbarnard

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of skbarnard
skbarnard

ASKER

Turns out we called Microsoft for this issue and found if we used the "run as" administrator option, we could alter existing or create new maintenance plans.  It appears we may still have to rebuild our SQL cluster but for now, this issue was resolved.