.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Accidentally deleted cluster resources

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi, Am new to cluster as well as SQL. I have a task to do restoration on a W2K3 Cluster, I have created a new disk partition and manage to restore my DB. But when I remove the disk parition resources, I have deleted the dependency resources, SQL Server and SQL Server Agent. Now I cannot access to the DB through Management Studio. I have tried adding back the 2 resources but was unsuccessful at bringing it online. Some error includes: Could not find any IP address that this SQL Server instance depends upon. Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available. Error code: 0x103. TDSSNIClient initialization failed with error 0x103, status code 0xa. Any help will be great.  

View Complete Post

More Related Resource Links

Any issues removing backup mount point cluster resources from SQL Server dependencies?

Win 2003, SQL 2005/SQL2008 64 bit enterprise failover cluster with 3 nodes and 6 instances. The mount points configured as cluster resources for the data/backup/logs. The entire cluster mount points are SAN replicated to a DR Site. But backup drives/LUNs are excluded from the replication. All the disk resources including backup LUNs are set to dependencies on the SQL Server server. The SQL Server is not coming on-line in the DR Site due to unavailability of the backup LUNs (failed resources). As per the documentation all the disk resources must be set to dependencies (http://support.microsoft.com/kb/835185). Thought it did not specifically mentions only Data/Log mount points and/or the backup LUNs as well. "The SQL Server 2005 resource depends on the SQL network name resource and the physical disk resources that hold its data. When mount points are being used together with the physical disks, each mount point must appear as a cluster resource. Additionally, each mount point must also be added as a SQL Server dependency. If only the root physical disks dependency is added and the mount points are not added, database corruption will occur on failover. Database corruption may also occur when SQL Server is restarted without failing over. "     What if I remove the backup LUNs from dependencies list. This will allow me to recover the SQL Server

SQL cluster resources getting failed often

Hi We have an active-passive cluster setup in our environment for the SQL application. Both the servers are windows 2000 SP4. In the last 24 hours the SQL cluster resources have failed twice. I am not sure of the correct tme nor the correct log location of where the resources failed.Please find below the cluster logs of the day on which the failure happened. Please find the logs in the below link: http://rapidshare.com/files/414371495/New_Text_Document__2_.txt

SQL server 2008R2 install on a server 2008 R2 failover cluster. Other resources won't failover to o

As the subject says, I've built a fresh install w2k8r2 and sql2k8r2 failover cluster. Sql works fine on the primary node, but when I test a failover it breaks. Specifically, if I were to stop the node1 cluster service (causing the cluster to switch to node2), windows changes the cluster DNS appropriatly and moves the shared storage just fine, but sql server doesn't failover.  Server Name, Disk Drives and Other Resources all go offline. I've verified that the advanced policies of the server name, IP, cluster drives all have both nodes checked as possible owners However, Other resources only lists node1 as a possible owner and there appears to be no way to add node2.  Under the Other resources, SQL Server and SQL Server Agent are listed. I'm sorta stumped, I've been combing the forums and have found similar issues, but nothing seems to explain why the two resources won't failover.

Accidentally deleted webpart, need to get it back or redo page (tried to add page, but rich text box


I just need to get the web part back! I accidentally deleted it! Please help!


If there is no way to do this, I could start over. I tried to add a new web part but the "Rich Text Box" isn't showing up in the "Content Query Web Part" box.



Accidentally deleted some records from a Table


 Hi to all :(

as my post say's i accidentally deleted some records from a sql table, my log file is huge so i believe my records are still there, is there a way to make a rollback or read the log file to search my records.

please tell yes and light me to the solution

i did this  delete * from myTable where 1=1 and -- column = 'something'.. forgot to uncommnet the last condition on the where  (i have SQL 2008 Enterprise server)


IT Programmer: Juan Carlos Hidalgo

How to detect and avoid memory and resources leaks in .NET application

Despite what a lot of people believe, it's easy to introduce memory and resources leaks in .NET applications. The Garbage Collector, or GC for close friends, is not a magician who would completely relieve you from taking care of your memory and resources consumption.

I'll explain in this article why memory leaks exist in .NET and how to avoid them. Don't worry, I won't focus here on the inner workings of the garbage collector and other advanced characteristics of memory and resources management in .NET.

SharePoint 2010 - Top 10 Resources to get you started

This post contains links to download evaluation software, guides, demo virtual machines and lots more, for both Developers and IT Professionals.SharePoint 2010 - Top 10 Resources to get you started

Resources for soup-to-nuts of website development lifecycle



 I'm looking for a website, or book, or some resource that can lead me down the path from website design to implementation/deployment. I know that covers a ton of material, but I am really looking for the bullet points, or high-lights, to make sure that I think of everything. I am mostly fuzzy on security measures and deployment since I haven't been involved in those aspects before.

Background:  I have been a programmer for many years, and with a little over 3 years' experience coding websites in vb.net/asp.net with sql server. Due to recent restructuring/layoffs at our firm, I find myself in the position of lead IT person - I'm feeling a bit underqualified but I feel this is my chance to work hard and step up to it. I'm very good at vb.net, master pages, css, asp.net, sql server. I'm worried that the person who was the lead before was doing a bunch of stuff that I'm not aware of...so I need to start learning more than just the code. I don't need lessons on how to code anything...I need to learn how it all gets put together - the next step up.

thanks for any suggestions!

JQGrid Loading deleted values



This is quite strange. here is the issue:

Some Info:

1. I'm using a multi-select jqgrid.

2. I have my own delete button to delete multiple orders

The problem:

When i press the delete button on the pager of my jqgrid, the records are deleted from the database but JqGrid shows some records (4-5). On refreshing the grid, correct numbers of records are shown.

Here is the code:

function delorder() {
        var amg = $("#horder").getGridParam('selarrrow');
        var cont = amg.length;
        if (amg.length > 0) {

ASP.Net account deleted. How to create it again?


 Hi I have created an intranet application using ASP.Net/IIS.

I normally need to web share the folder and allow full permission to ASP.Net user account.

However, I carelessly deleted this account. How to create it again ?

Pls help.... thanks.


Basic Instincts: Resources and Localization in ASP.NET 2.0


In this installment of Advanced Basics Ted Pattison discusses the localization of Web sites in ASP.NET 2.0.

Ted Pattison

MSDN Magazine August 2006

Basic Instincts: Resources and Localization


There are two ways you can utilize resources such as strings, images, and text-based files from your Microsoft® . NET Framework-based application. You can embed them directly in the app or you can load them from an external file.

Ted Pattison

MSDN Magazine May 2006

Built For Speed: Develop Turbocharged Apps For Windows Compute Cluster Server


This article explores the services provided by Compute Cluster Server 2003 and the tools provided by Visual Studio 2005 that will help you develop High-Perfomance Computing applications.

Rich Ciapala

MSDN Magazine April 2006

New Stuff: Resources for Your Developer Toolbox


Databeacon Smart Client software allows users to perform data analysis, turning relational data from any data source into online analytical processing (OLAP) cubes that can be explored and manipulated using one of three Databeacon viewers.

Marnie Hutcheson

MSDN Magazine December 2005

New Stuff: Resources for Your Developer Toolbox


Code refactoring is defined as the act of changing code without changing what it does. The actual work involved in refactoring-extracting methods from oversized modules, tidying up and unifying variable names, identifying unhandled exceptions, and all the other cleanup, simplification, and standardization chores-can be daunting, indeed, and risky too.

Marnie Hutcheson

MSDN Magazine November 2005

New Stuff: Resources for Your Developer Toolbox


ActiveReports for . NET 2. 0 by Data Dynamics is written in C# and integrates with the Visual Studio® . NET development environment to let you create dynamic reports and charts. Drop the Report Viewer control on your Windows® Form or Web Form, specify the data source and authentication information for the data connection wizard, and it builds the connection string for you.

Marnie Hutcheson

MSDN Magazine October 2005

New Stuff: Resources for Your Developer Toolbox


From my first look at VG. net V2. 4b by Prodige Software Corporation, it seemed like just another typical graphics add-on, but as I discovered what a potent tool it is for Visual Studio® . NET graphical interface development, I became more and more impressed.

Marnie Hutcheson

MSDN Magazine September 2005

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend