Installing SQL Server 2008 Clustering on Windows Server 2008
In this podcast we are going to install SQL Server 2008 Clustering on Windows server 2008. I’ve already made my both the nodes clustered with Windows server 2008 and the details are below.
Below are the list of SQL Server 2008 editions supporting clustering.
- SQL Server 2008 Enterprise Edition (16-node failover clustering)
- SQL Server 2008 Standard Edition (2-node failover clustering)
- SQL Server 2008 Developer Edition
Installing MSDTC as Cluster Aware Service
This is my first podcast for sql-articles.com. In this article we are going to discuss on Installing MSDTC as cluster aware service on Windows server 2008. We need this service as cluster aware because this is the perquisite when configuring SQL Server 2008. Watch the video and post your feed back in our discussion board.
Configuring Failover Clustering in Windows Server 2008
I have planned to configure SQL Server 2008 clustering on Windows Server 2008 Clustering. To do this, first I need to configure Windows Server Clustering. Now a days DBA’s are not only working on RBMS platform, they should also have sufficient knowledge in their operating system on which their RDBMS is running. As a DBA we shouldn’t look into SQL Server cluster alone, we should also take part in windows clustering too. In this article I’m going to configure failover clustering in Windows server 2008.
SQL Backup on NTFS Compressed folder
I’m starting this topic since last week I had faced a backup issue with compressed drive. In one of our server we have used compressed folder to take backup of our SQL databases. This is working fine and the db is used for OLTP application and it had grown about 73GB. Now we have started facing backup failures only for that database alone all other databases (less than 10GB) are running fine in the maintenance plan. I’ve checked the machine performance and SQL Server is the only process using 50% of CPU and 3GB of memory, other than that the server is not under stress and in fact that box is dedicated to SQL Server.