Post reply

data file corrupted and became 0 size on server restart

  • January 6, 2009 at 11:23 am

    #129731

    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:31 am

    #921998

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://qa.sqlservercentral.com/Forums/Topic630817-266-1.aspx

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 6, 2009 at 11:41 am

    #922007

    sorry. first time post a topic here. only replied a couple previously.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply