Error Detaching database -
11-17-2008
, 10:19 AM
Hello all,
I have a one-node Windows server 2008 x64 Cluster with Sql Server 2005 x64
installed on it. Shared storage is connected throught FC to a HP MSA1000.
The problem I have is that whenever I detach a database from the SQL Server
Management Studio, the disk resource fails.
I have an event in the Event log that states that the filesystem may be
corrupt. The system itself launches a chkdsk that finishes without error,
but the disk can't be brought on-line.
If I place the disk in maintenance mode, I can run another chkdsk that
finishes sucessfully, and have access to the file system. After that I
place the disk back to normal mode, but fails again with the same error.
The only way I have found to "recover" the disk is place it in maintenance
mode, move the database/log files to another location, FORMAT the disk,
copy back the moved files, and then I can bring the resource on-line and
works without problem.
Any one have any hint that helps' me find what's the problem?
Thank you |