Home Forums SQL Server 2005 Data Corruption Help Please - DBCC Check Failed-The operating system returned error 87 RE: Help Please - DBCC Check Failed-The operating system returned error 87

  • Hi opc.three

    Well, i started to back up all the databases since i did not get any backups since sat. I am using SSMS and if the DBCC CHECKDB fails on any database, the backups do not run, since i do that first.

    I know, pretty poor. I am going to have to address this, but anyway i was backing up existing databases and started getting the same problem on two other databases. I found this error also

    "A system assertion check has failed. "

    Not good according to Gail. Lots of dump files and "BugCheck Dump" files. Not good also.

    Anyway as I was doing a check on the third database, the server crashed.

    After it came back up and I started the services, I ran a check again on the bad databases.

    To my surprise, all the databases that showed a problem, passed the check and I was able to get full backups. So I am not sure what the cause is at this time.

    I am trying to get an Admin to get me a ticket with MS to see if they can shed some light on issues we had.

    Thanks

    Jim