Does the Rebuild Master utility have a repair possibility?
Posted on 2006-05-27
Hello out there.
I just found out that MS SQLServer ver 8 has not done any backups since May 9'th. The msdb is marked SUSPECT. The Windows Server 2003 application log from May 10 talk about
Error: 823, Severity: 24, State: 2
I/O error (torn page) detected during read at offset 0x00000000bb2000 in file 'd:\apps\SQL Server\MSSQL\data\msdbdata.mdf'.
The Windows System log got corrupted at the same time, us having plenty power problems so I believe the SUSPECT.
I have no backup of the msdb - only production databases, and have not any install CD handy (Has to come down from Europe with DHL, I am in West Africa).
Looking up the Rebuild Master utility is says it can repair a corrupted Master DB. Can it also build a new MSDB. My Master is fine and so are the other DB's, so I would very much like to avoid to run scripts and reload data if possible.
I will be back online Monday.
Kind regards Peter Vibede