Posted by David Greenberg on 02/16/06 12:16

Hi
When trying to create an SqlServer job, clicking OK' I got the message
"Error 823: I/O error (torn page) detected during read at offset..... in
file 'd:\sqlserver\MSSQL\data\msdata.mdf'. The job was not saved"

I asked about the problem a little to find out that I need to restore a
backup of MSdb because the job definitions are there. I rrad some other
place (I can't remember where) that in order to restore MSdb I need to
restore a backup of Master as well.

Can anyone give me some more information on this.
Is there any way else to do it besides restoring the backup ?
To restore, do I need to recreate the database or just restore the
appropiate backup file ?

David Greenberg

[Back to original message]