Browse by Tags

SQL Server 2005 Failover Clustering on Windows Server 2008 - webcast

Published 16 May 8 9:13 PM | SSQA.net

Windows Server 2008 is on full fledged wave now after it has been launched in February and it is obvious that many questions will be flying around about supportability & manageability for existing SQL Server versions such as 2005 at the moment. Think...

Filed under: sql server, best practices, clustering, failover, windows 2008, new features

SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

Published 8 May 8 3:42 AM | SSQA.net

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability

SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions

Published 18 March 8 6:23 AM | SSQA.net

You may be aware that Database Mirroring is an important High Availability [HA] option available within SQL Server 2005 version. Having this HA option within your Sharepoint farm where the databases are associated to failover, then you must note few issues...

Filed under: sql server, high availability, technet, database, best practices, sharepoint, database mirroring, failover, links

Setting up Database Mirroring using Local Account

Published 10 March 8 5:43 AM | SSQA.net

We had a need to setup Database Mirroring for a Disaster Recovery Project. We were at time running SQL 2005 Std SP1. i had to start the SQL Server Service with the startup parameter -T1400 to enable Mirroring. For DB Mirriring to work the SQL Server Service...

Filed under: high availability, disaster recovery, database mirroring, failover

FIX: Error message when you start a database mirroring session in SQL Server 2005: "Communications to the remote server instance 'TCP://<ComputerName>:<PortNumber>' failed before database mirroring was fully started"

Published 4 February 8 6:3 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, services, kba, database mirroring, failover, endpoint, port

Error - There is not enough disk space on the destination disk, during a SQL Server failover cluster installation

Published 4 January 8 2:51 AM | SSQA.net

Had an interesting problem on one of the SANs that will be used to setup a failover clustering installation. The issue error "'There is not enough disk space on the destination disk for the current SQL server data files" and when I have...

Filed under: sql server, cluster, disk space, hardware, administrator, failover, errorr, installallation, not enough storage

The DHCP support is not available when you install SQL Server 2005 on a Windows Server 2008 failover cluster

Published 2 January 8 1:4 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications The DHCP support is not available when you install...

Filed under: sql server, kba, longhorn, clustering, network, failover, windows 2008, dhcp

FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005

Published 26 September 7 3:34 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, kba, database mirroring, principal, transactions, mirror, failover

Database Mirroring: naming resolution issues during failover connectivity

Published 24 September 7 10:13 AM | SSQA.net

Within a Database Mirroring session within an automatic failover situation it may fail with the error : "The server network address "%.*ls" can not be reached or does not exist. Check the network address name and reissue the command"...

Filed under: sql server, connectivity, database mirroring, network, failover, resolution, continuity, lmhosts, naming

Information and issues with Kerberos security within SQL Server 2005?

Published 31 August 7 4:45 AM | SSQA.net

What is the Kerberos Authentication? What are the security features difference between Windows 2000 and 2003 versions? How it is behaved within Failover Clustering? How to enable Kerberos Authentication Including SQL Server Virtual Servers on Server Clusters...

Filed under: sql server, security, windows, audit, clustering, authentication, failover, kerberos

How to change the network IP addresses of SQL Server failover cluster instances

Published 29 August 7 2:56 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications How to change the network IP addresses of SQL Server failover cluster instances http...

Filed under: sql server, kba, connections, clustering, network, failover

How to rebuild or move a MSDTC installation to be used with a SQL failover cluster

Published 22 August 7 4:3 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications How to rebuild or move a MSDTC installation...

Filed under: sql server, high availability, kba, installation, clustering, msdtc, failover