Clustered instance will not start after removing builtin admins
After removing the builtin administrators group the clustered services do not start. Perry Whittle walks through the issue and what you can do to correct things.
2010-04-16
1,484 reads
Clustering
Pre Check List for 64 BIT SQL Server 2008 Cluster Installation
My tips for cluster installation with Windows 2008 and SQL 2008 on a 64 BIT server which is clustered.
2009-12-31
7,639 reads
Understanding why there is still downtime with Microsoft Clustering
I want to institute a high availability solution for SQL Server with no downtime. I am planning on using Microsoft clustering, but I have been told that in the event that the cluster moves the SQL Server from one physical server to another, that there is some downtime. Why is this so?
2009-11-24
4,324 reads
SQL Server 2008 Failover Clustering
This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover cluster architecture and concepts for Windows Server (2003 and 2008) and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.
2009-10-02
3,698 reads
Attribute Discretization: Using the “Clusters” Method
Join BI Architect Bill Pearson as he leads hands-on practice with the “Clusters” discretization method in Analysis Services. In this article we continue to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.
2009-08-04
2,163 reads
Planning Ahead - Single Node Clusters
People don't plan to fail; they fail to plan. Single node clustering provides organisations with a ready made scale-up or high availability platform from the beginning of the deployment.
2009-06-17
6,874 reads
Setting up a SQL cluster under MS VS2005 R2 Part2
Continuing with setting up a 2 node SQL cluster under MS Virtual server 2005 Ent R2 SP1, Perry Whittle looks at the SQL configuration in this article.
2009-05-15
3,929 reads
Setting up a SQL cluster under MS VS2005 R2 Part1
This article from Perry Whittle looks at setting up a 2 node SQL Server cluster under MS Virtual server 2005 Ent R2 SP1. Something that is very handy for testing clustered servers.
2009-05-13
5,154 reads
Cluster Information
This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources
2009-05-08 (first published: 2009-04-15)
1,408 reads
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4
How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?
2009-04-10
3,074 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers