Category: FAQ
DTS package error "Cannot find specified package in the storage location specified".
How to get resource usage of an executing query in SQL Server without using SYSMON/PERFMON utility?
How do you get rid of users that are already in the database on the backup server when a restore starts?
Does a SQL Server cluster support load balancing?
Can you provide the scripts that you use to transfer (copy) logins from a primary server to a secondary server?
We have a SQL Server 2000 cluster. I have been trying to get SQLMail to work with it, but have failed. What am I doing wrong?
We are planning a new SQL cluster. We intend to have the two servers separated by 100 meters. Will the cluster's shared disk array be a single point of failure for us?
How do I change the IP addresses of clustered SQL Servers?
My manager has asked me to put together a plan for a backup server for our production server running SQL Server. Should I use log shipping or clustering?