SQL Server Clustering

We are unable to install SQL Server 2005 on additional node on top existing cluster setup running Windows 2003 x64 bit operating system?

When we are trying to install SQL Server 2005 x64 bit on the second node, it is listed as ‘unavailable’. Further we are unable to install SQL Server 2005 x32 bit that hangs on installing the SQL Server cluster resources. How can this issue be resolved and how to install SQL Server 2005 x64 bit […]

What is the usage of the WITNESS instance in SQL Server 2005 Database Mirroring?

Question We are considering running our SQL Server 2005 database server on a Dell 2950 x64. We also want to implement database mirroring, and are considering using an HP DL360 as a witness server. In addition, the mirrored databases will be running in a VM running on ESX. Is it a feasible configuration to use different […]

What are the specific tasks assigned to System Administrator (SA)role in SQL Server? How can I disable or rename SA account in SQL Server 2005?

Question: What are the specific tasks assigned to System Administrator (SA)role in SQL Server? How can I disable or rename SA account in SQL Server 2005? How to track password changes on SA account? Solution: There are few caveats for the beginners in SQL Server to be aware about in managing roles and security. The […]

How to view properties when trying to view the same index details in SQL Server Management Studio ?

Question:   I’m able to add and edit Indexes using SQL Server Management Studio (SSMS) successfully, but unable to view properties when trying to view the same index details in SSMS. How to resolve this problem?  Answer: The user can view database.table.index properties using SQL Server Management Studio without any issue if that user has the privilege to perform such a task. But it is not possible to view an index’s properties if […]

How to hide databases in SQL Server Management Studio from unauthorised users?

Question: If a user is not authorized to see a database can I exclude that database from even appearing in SQL Server Management Studio for that specified user or group? Answer: Until SQL Server version 2000 it was not possible to hide the database information from being displayed on SQL Server Enterprise Manager. In SQL Server 2005 […]

How to allow access to non sysadmin users to view status of sysadmin owned scheduled jobs?

In SQL Server 2000 only sysadmin (sa) privileged users can manage the scheduled jobs under SQL Agent tasks. In general any user can create a job, but a job can be edited only by its owner or members of the sysadmin role. The user can also view its history. Viewing a job’s history allows you to […]

I am trying to backup my databases from my clustered shared array to a local disk, but I can’t see the local disk when I run the Backup Wizard. Why?

This is a problem with both SQL Server 7.0 and SQL Server 2000 clustering. I don’t know if this is a bug, or there was some intentional reason for doing this. But there is at least one work-around that I am familiar with. The work-around is to create a backup device on the local disk […]

Is it advisable to run both Terminal Services (application mode) and SQL Server on the same cluster together?

Technically speaking, what you want to do is possible, but I wouldn’t recommend it. One problem is that Terminal Services (Application Mode) has some limitations under clustering, and is not fully cluster aware. But the biggest problem you will run into is performance. Terminal Services (Application Mode) is a huge resource hog. The same is […]

I have a question on how to uninstall a SQL Server 2000 instance installation from a Windows 2000 cluster.

Question I have a question on how to uninstall a SQL Server 2000 instance installation from Windows 2000 cluster. I tried to use the setup program on the install CD, but I am not getting the option to uninstall when I run the setup program. Let me give you brief scenario as what has happened: […]

I am having a problem installing an Active/Active SQL Server cluster.

Question I have recently set up a two-node cluster using Windows 2000. I have a single RAID 5 shared disk array that is sliced into two logical disks which appear in Windows 2000 Disk Manager as Disk 1 and Disk 2. I have also created one primary partition on each disk and have assigned drive […]

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |