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
Navigation:
[Reply to this message]
|