SQL Server Agent doesn't start after upgrading to build 3239
Tue, 29 Apr 2008 20:54:01 -0700
I have an active/active cluster running under SQL Server 2005 64 bit sp2.
After upgrading to build 3239 the SQL Server Agent won't start anymore... The
error captured in the log file is:
SQLServer Error: 22022, CryptUnprotectData() returned error -2146893813,
'Key not valid for use in specified state.' [SQL ...
|
How to Backup SQL 2005 Cluster
Tue, 29 Apr 2008 18:16:00 -0700
Hello,
I have recently configured two node SQL 2005 failover cluster. I'm wondering
if anybody has some king of document/article on how to backup the cluster
(both servers and databases). I'm planing to use NetBackup 6.5 for this
purpose.
Any advice is appreciated.
Thanks!
Sigitas ...
|
MSDTC
Mon, 28 Apr 2008 08:47:01 -0700
Hi,
I have built a 2005 two node sql cluster and we are seeing very poor client
access speeds. Clearly there could be a zillion reasons for this and I am
trying to narrow them down.
My question is about location of the MSDTC. I currently have the MSDTC
located on the shared disks that also holds the data ...
|
Install cumulative update package 7 on SQL cluster
Fri, 25 Apr 2008 07:00:00 -0700
Does anyone have procedure on installing Cumulative update package 7 for SQL
Server 2005 Service Pack 2 on 2 node SQL 2005 cluster? Thanks.
William ...
|
SQL Server 2000 and 2005 Cluster coexisting?
Thu, 24 Apr 2008 10:00:00 -0700
Hi
SQL Server 2000 and 2005 Cluster coexisting...?, MS say yes but I wonder if
it is a good idea in an production environment...
Someone has experience in this configuration?
thanks in advance...
--
Chevy ...
|
SQL queries are slow in SQL Server 2005 when compared with SQL Server 2000
Thu, 24 Apr 2008 19:06:49 +0530
Hi,
I have installed SQL2000 and SQL2005 on the same computer accessing the same
DB
When run the following simple queries the performance is as follows
Could some one please advice on how improve the performance on these queries
to run on SQL2005 ?
Are there any settings to be done in SQL2005 ...
|
How to upgrade to SP2 on active/active
Wed, 23 Apr 2008 19:45:00 -0700
Hi,
I need a simple procedure to upgrade our SQL2005 active/active cluster. It's
presently unpatched. From what I understand I need to do the following :
1- Failover node 2 ressources to node 1
2- Log on node 1 and install the SP2 on the two instances
3- Failover node 1 and node 2 ressources to nod ...
|
|
|
Old SQL Cluster name problems:duplicate name exists on the network
Tue, 22 Apr 2008 07:57:00 -0700
I had a cluster named oldcluster. I created a new cluster called newcluster.
I evicted node1 from oldcluster, ran "cluster node node1 /forcecleanup. I
changed the dns entry for oldcluster to point to the newcluster ip. Then
added node1 to newcluster.
When I failed newcluster over to node1 I started getting ...
|
Active/Active/Passive questions?
Mon, 21 Apr 2008 11:11:00 -0700
I have setup Active/Passive in the past with no problems
With Active/Active/Passive are all nodes on the same heartbeat?
Is the correct Private IP configuration correct?
Node1 10.0.0.1
Node2 10.0.0.2
Node3 10.0.0.3
If I go with this setup do both active nodes point at the passive mode as a
failover?
Doe ...
|
Creating BCM's Database on a Clustered SQL server
Mon, 21 Apr 2008 14:03:50 -0400
SQL 2005 Enterprise running on Windows 2003 Enterprise confgured as
Active/Passive cluster. Having problems creating the BCM database using the
"Outlook 2007 with Business Contact Manager: Database Admin Tool"
(http://www.microsoft.com/downloads/details.aspx?FamilyID=b8e7aa0f-f593-4fb4-b822-dd662af1a6cb&displa ...
|
