September 5, 2008 at 5:19 am
We had this situation in which SQL SERVER 2005 crashed. We looked at the logged files and noticed that when it try to re-start, an error indicated that the MDF file was no longer available. This SQL server is clustered. The database size is of about 20GB. There is no clear error to indicate what took place. Has anybody experienced something similar?
We recovered from this problem, but I am trying to identify the problem.
thanks.
https://ozkary.com
September 9, 2008 at 3:14 am
Had something that might be similar - the sql resource came up before the disk resources and therefore sql server couldn't find the database files
September 25, 2008 at 1:07 am
Can you please explain how you recovered from the issue ?
Raghavender Chavva
Thank You.
Regards,
Raghavender Chavva
September 25, 2008 at 7:39 am
proably restored from a backup.
Gethyn Elliswww.gethynellis.com
September 25, 2008 at 4:56 pm
we restored the database from backups. the concern here is the fact that the files were deleted. there is no concrete evidence on what could of happen, but it could have been a hardware issue.
https://ozkary.com
September 28, 2008 at 3:24 am
ozkary (9/25/2008)
we restored the database from backups. the concern here is the fact that the files were deleted. there is no concrete evidence on what could of happen, but it could have been a hardware issue.
That's very unlikely... 99 times out of 100 you are gonna find human action is involved in such "misterious" issues. How good is your security?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 28, 2008 at 7:31 am
SQL Server doesn't automatically delete the files, someone had to move them or delete them. I'd investigate moves. Search for them on the drives, a shaky mouse hand could have moved them accidentally.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 8, 2008 at 12:02 pm
An MDF file is never deleted automatically by SQL Server. Not even in a clustered environment. Your files probably got renamed or moved by some user due to network latency of the mouse cursor or keyboard. Look for files that are similar in size what your mdf was prior to it dissappearing, also look for files by changed date.
Hope this helps.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply