January 6, 2009 at 11:25 am
Hi gurus,
We've got a weird problem lately. At one time, we used Surface Config to stop the db server and then restarted the machine (we've actually done that many times before).
The problem is: after the machine came back, one of the database's data file became 0 in size and the db is completely down.
We have:
SQL Server 2005 SP2 Enterprise
Windows 2003 R2 SP2 64bit
HP MSA 2000 storage server
The database has 4 data files, one on each disk array of RAID5.
Have somebody here seen this before? If so, could somebody shed some light on the cause of this problem?
thanks a lot.
January 6, 2009 at 11:32 am
IO sub-system glitch? It's pretty much the only thing that comes to mind.
I assume there's all sorts of errors in the error log about 'cannot open file', etc.
Got a backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2009 at 11:52 am
do you think the problem is on the OS side or on the storage side?
January 6, 2009 at 12:41 pm
GilaMonster (1/6/2009)
Got a backup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 12:47 pm
James Zhang (1/6/2009)
do you think the problem is on the OS side or on the storage side?
< Shrug > Out of my area of expertise. Absolutely no idea.
Anything interesting in the windows event log? Is the RAID array giving errors?
Is it a SAN or a direct-attached array? If a SAN, are the SAN diagnostics giving anything useful?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply