Display: Cloud | List
Most Popular Tags
Results (22 total) All > cluster (x)
Edition upgrade : SQL Server Clustered Environment (How to: Upgrade to a Different Edition of SQL Server 2008 R2 (Setup))
SQL Server in a clustered environment: Running edition upgrade on one of the nodes of SQL Server cluster is sufficient. This node can be either active or passive, and the engine does not bring the resources offline during the Edition Upgrade. After the edition upgrade it is required to either restart the SQL Server instance or failover to a different node.
Last modified by Chaitanya Medikonduri on 10/10/2011 9:43:04 AM
Tags:  cluster  edition;  server;  sql  upgrade;
Failover Clusters without Shared Storage (High Availability Solutions Overview)
Microsoft does support "multi-site clusters", which basically allows failover clusters to be extended across geographically dispersed locations. Multi-site clusters rely on 3rd party replication solutions from storage array vendors and software host based replication solutions to keep the data in sync across sites. http://www.microsoft.com/windowsserver2008/en/us/failover-clustering-multisite.as
Last modified by David Bermingham on 10/23/2010 12:56:14 AM
Tags:  cluster  multi-site  sql
Although it's not best practice to place a ldf or mdf in the root of a drive ir can happen. As the permissions for the administrators and service account get removed the cluster service throws a hissy fit if the ldf or mdf is in the root of a cluster resource disk. It's not easy to fix either as if you don't fix the file permissions the drive goes offline again. I have to question the wisdom of r
Last modified by Thomas Lee on 8/2/2010 11:41:29 AM
Tags:  2008  cluster  offline  resource  sql
Best Practices for Clustered Environments (Before Installing Failover Clustering)
Hello, See the following link for some best practices for clustering environments:http://www.sqlcoffee.com/HighAvailability05.htm Regards, Alberto Morillo SQLCoffee.com
Last modified by Alberto Morillo on 11/9/2010 2:49:47 PM
Tags:  best  cluster  practices
Best Practices for Clustered Environments (How to: Create a New SQL Server 2005 Failover Cluster (Setup))
Hello, See the following link for some best practices for clustering environments:http://www.sqlcoffee.com/HighAvailability05.htmRegards,Alberto MorilloSQLCoffee.com
Last modified by Alberto Morillo on 1/11/2010 3:06:04 PM
Tags:  cluster
Failover Clustering and Disk Mirroring Support (High Availability Solutions Overview)
Failover Clustering can protect against disk failure if you replace the physical disk resource with a replicated volume resource from a 3rd party ISV (SteelEye DataKeeper or DoubleTake GeoCluster) or array based replication solution (EMC, IBM, ect). This solution gives you all of the benefits of clustering as well protection against disk failures.This article walks you through the steps of creat
Last modified by David Bermingham on 12/8/2009 2:31:32 AM
Additional Steps for SQL Clusters (How to: Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager))
If you're running SQL 2005 in a failover cluster configuration and you can't get the SQL Server Configuration Manager to list the certificate in the drop-down box where it should be here are some tips. Ensure that the certificate was created with the FQDN of the virtual/cluster name.Follow the steps in "To provision (install) a certificate on the server" above to navigate to the certificate and
Last modified by A.Lockwood on 11/28/2008 5:18:44 AM
Additional Steps For Failover Clusters (How to: Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager))
This applies to SQL 2005 for sure, but I have yet to test it on SQL 2008. If you're running SQL 2005 in a failover cluster configuration and you can't get the SQL Server Configuration Manager to list the certificate in the drop-down box where it should be here are some tips. Ensure that the certificate was created with the FQDN of the virtual/cluster name. Follow the steps in "To provisi
Last modified by A.Lockwood on 11/28/2008 5:19:43 AM
Web Server Certificate Will Work (Encrypting Connections to SQL Server)
If you're not sure what sort of a certificate to request a "Web Server" certificate will get you what you need. Just be sure to set the name to the FQDN like it says and if you're running a cluster be sure to use the virtual/cluster FQDN. If you happen to be running a SQL 2005 cluster with a SQL Server service account that is a domain account but isn't a local admin you will need to take additiona
Last modified by A.Lockwood on 11/28/2008 4:53:46 AM
Tags:  2005  cluster  sql  winhttpcertcfg
IP=' ' configuration parameter in unattended settings.ini file (cluster install) (How to: Install SQL Server 2005 from the Command Prompt)
When using the IP="ip address,Network Name" the Network Name part is the name of the network in the cluster networks NOT the Windows Network interface name. If you do not not specify the correct network name according to the Cluster setup, then it will fail with a "network name not found" error.
Last modified by Ben Miller - DBAduck on 11/4/2008 12:54:45 AM
Tags:  cluster  contentbug
Page view tracker