SQL 2008 R2 Cluster Setup: Easy? Not So Much.
The SQL Server 2008 R2 setup program crashes sometimes leaving you with a "half installed" instance: this is about how I repaired the setup on a populated cluster.
2011-11-29
4,513 reads
Clustering
Tips for Upgrading a Cluster to SQL 2008 - Part 1
This article describes my experience in upgrading a four node cluster with three active instances to SQL 2008
2011-11-14
3,031 reads
Automatic Alert Generation in the event of SQL Server Cluster Failover
We had a requirement where we were asked to generate automatic email notification in the event of a failover.
2011-10-06
4,695 reads
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3
This article continues the series on how to create a 2 node Windows\SQL Server 2008 cluster with a look at slipstreaming the service pack and cumulative updates needed.
2011-08-12
5,682 reads
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2
Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.
2013-12-24 (first published: 2011-07-12)
9,677 reads
Getting the most out of your SQL Server 2008 Cluster
Gain an insight into how to use your SQL Server cluster for more than just high availibility in this article from Mark Jones.
2011-05-26
3,914 reads
2011-03-15
2,312 reads
Creating A SQL Server 2008\2008 R2 Failover Cluster
Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance
2013-12-23 (first published: 2011-01-19)
18,555 reads
Uninstalling a SQL Server Clustered Instance
I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQL Server 2008 R2?
2010-12-06
3,572 reads
How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster
Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.
2010-04-26
2,048 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