Browsing articles tagged with " cluster"
May
1
2012

sqlstate = HYT00; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Timeout expired

Error in windows event logs: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Timeout expired  —————————- Suggestions from MSDN forum link: Reference link: http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/e5b8d938-e529-40f5-bdaa-601a8f6d7aca/ From the error it looks like there was issue with your network. Make sure you have a dedicated Heartbeat Network configured and that it is designated as such in Cluster Administrator. The public facing network can be configured for both Public […]

Apr
17
2012

MSDTC and SQL Server 2005 Clustering

While searching for questions, Why MSDTC is required, in which it needs to be configured, is it must for SQL Clustering, etc. Please find below the analysis done by going through several forums and msdn articles,

Apr
8
2012

SQL Server 2008 and R2 Cluster Best Practices

http://blogs.msdn.com/b/pamitt/archive/2010/11/06/sql-server-clustering-best-practices.aspx Read about this in above article, few highlights to remember,

Mar
11
2012

Upgrade SQL Server 2000 Active/Active cluster to SQL Server 2005 and Windows 2003 with High Availability

Part 1: Team composition and upgrade option pros and cons – http://searchsqlserver.techtarget.com/tip/Upgrade-Active-Active-cluster-to-SQL-Server-2005-and-Windows-2003 Part 2: Restoring a SQL Server database to a transition server – http://searchsqlserver.techtarget.com/tip/How-to-restore-SQL-Server-database-to-transition-server-during-an-upgrade Part 3: SQL Server high availability when upgrading to SQL Server 2005 – http://searchsqlserver.techtarget.com/tip/SQL-Server-high-availability-when-upgrading-to-SQL-Server-2005 Part 4: Upgrade live applications to SQL Server 2005 for high availability – http://searchsqlserver.techtarget.com/tip/Upgrade-live-applications-to-SQL-Server-2005-for-high-availability Part 5: Monitor database mirroring and replication after upgrade – http://searchsqlserver.techtarget.com/tip/Monitor-database-mirroring-and-replication-after-a-SQL-Server-upgrade

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2017
M T W T F S S
« Nov    
 123
45678910
11121314151617
18192021222324
25262728293031

View Post by Categories

%d bloggers like this: