dbTalk Databases Forums  

Error Detaching database

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Error Detaching database in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Juan Miguel Cervantes
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.