• GilaMonster (7/15/2013)


    That is corrupt beyond the point of being able to identify objects. You've got fatal metadata corruption and allocation page corruption.

    You're going to be very lucky if you get much at all out of that.

    Go through the tables one by one (select name from sysobjects where xtype='U'), see if you can generate the script, see if you can select any of the data. I suspect a good number of objects will fail. It will take quite some time.

    May be easier just to go back to the last good backup and accept that everything since is lost.

    Many Thanks Gila!

    ** NOW JUST NEED THE ADMINS TO MOVE THIS THREAD TO THE SQL 2000 FORUM **