corruption in master table

[ktigre]

I believe I have corruption in the table MASTER and MSDB as the repair processes won't run. is there anyway to find out where the corruption is, and to repair it without any loss of data? I'm not too familiar with SQL, but if you have a general way to do it I can probably figure out how to do it.

Thanks,
Chris

 

[sahernandez]

Do you know what is the status number?
and also and not sure for the master, but for the msdb
if you can recovery with SQL,
try this
--firts
EXEC sp_detach_db 'pubs', 'true'
--second
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\mssql7\data\pubs.mdf',
@filename2 = N'c:\mssql7\data\pubs_log.ldf'

But try firts with SQL recovery DB

 

[toetag]

Thats timing. I'm working with microsoft to fix a corruption in my master DB. They had me run DBCC NEWALLOC and DBCC CHECKCATALOG and the results of the NEWALLOC showed me that my syslog was corrupted.

Might try DBCC NEWALLOC to see where the corruption lies.


(Just a suggestion. If I was the expert, i'd not have had to call microsoft and opened a trouble ticket with them)