Hi All The MSDB database on our development server was marked as Suspect, there was no backup. I copied the .mdf and .ldf to a different location and ran the instmsdb.sql script to rebuild the MSDB from scratch. All scheduled jobs, job history among other info are now lost. I need a list of the last restore date of all databases on that instance. When trying to attach the .mdf and .ldf, i get this error: "The log scan number (363321:176:24) passed to log scan in database 'MSDB2' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup." When trying to attach the .mdf only, i get this error:"The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure." Using SQL 2008 Any ideas?
The only option you have at this point would be to pay someone [like Paul Randal] who knows how to modify the internal structures of a SQL Server database to attempt a recovery, and there's no guarantee. Your database is corrupted. It's gone. Set up backups on the new server. And test the backups to ensure they're working. :