Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 SQL 2005 Cluster Crashes..

Author  Topic 

apatel4000
Starting Member

4 Posts

Posted - 2008-10-01 : 07:05:29
We have our SQL cluster all setup and failover etc. works as expected between nodes. Our setup consists of the following:-

2x HP Proliant G5 DL385
Windows x64 R2 SP2 (AMD Optrn)
HP Storage Works MSA500 G1 (Firmware 1.90) SCSI

I have updated all firmware & drivers on all controllers etc. to find that when we attempt a restore using Redgate SQL-Backup5, to a drive on the MSA (clustered resource), the restore takes down the entire cluster and the all servers become unresponsive. A hard restart of the MSA is required followed by a restart of each physical server in order for the servers to see the array.

Can anybody shed any light on this? I've adjusted the cache ratio on the MSA but no success.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-01 : 13:00:24
Check the cluster logs. Contact Red Gate to let them know that their software is crashing your system.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

apatel4000
Starting Member

4 Posts

Posted - 2008-10-02 : 04:07:22
quote:
Originally posted by tkizer

Check the cluster logs. Contact Red Gate to let them know that their software is crashing your system.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog




Thanks Tara

Its interesting because yesterday we performed a conversion on the database from Redgate to native SQL so we tried to perform the restore using the built in SQL restore tool. Again this crashed the system. Worked fine on the first occassion, but the second restore of the same DB always take the cluster down.

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-02 : 12:45:51
Sounds like you need to contact MS PSS for help on the crashes.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -