Database corruption

Last Post 15 Feb 2011 06:29 AM by rm. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
river1
New Member
New Member

--
14 Feb 2011 07:58 AM
Hi Masters,

      Today a person from other department gave me two files (one mdf and one ldf).

The person told me that their Database Server crashed and they did not had recent backups.....

The have formated the server and installed windows again................

Now i have two files in my hands...


When i attached the files i all seem good, but when i do a DBCC checkDB (SQL Server 2000)

I receive the following message:


Server: Msg 8966, Level 16, State 1, Line 1 Could not read and latch page (1:242) with latch type SH. sysobjects failed. DBCC execution completed. If DBCC printed error messages, contact your system administrator.


I think, but not choore that this as something to do with metadata...

Can someone help?

Thank you
russellb
New Member
New Member

--
14 Feb 2011 11:56 AM
Looks like SysObjects is corrupt.

Run DBCC CHECKTABLE(sysobjects) WITH NO_INFOMSGS, ALL_ERRORMSGS.

But it is almost certaint that the only thing you can do at this point is to export (BCP out) as much data as possible.

Another lesson in taking frequent backups.
rm
New Member
New Member

--
14 Feb 2011 12:19 PM
Time to call MS support if you really need to recover it.
river1
New Member
New Member

--
15 Feb 2011 12:46 AM
hum.... today the person told me that the server was not down.......

I entered the server and i can't start SQL Server 2000.   It is because the master database is corrupt.

Once again... They don't have Backups of the master.

I'm thinking in rebuilding the master database but at the same time i think it will not help in recovering this particular database...

What do you think?
rm
New Member
New Member

--
15 Feb 2011 06:29 AM
Rebuild master will cleanup all data in it and msdb.


Acceptable Use Policy
---