Posted by Erland Sommarskog on 02/17/06 00:38

David Greenberg (davidgr@iba.org.il) writes:
> 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.

I can't find any information about this. What I did find in Books Online
was that if you run the Rebuild Master utility, you will need to restore
msdb, as this utility writes a new msdb.

> Can anyone give me some more information on this.
> Is there any way else to do it besides restoring the backup ?

DBCC with various repair options may be an alternative, but I would
certainly prefer a backup if there is one recent.

> To restore, do I need to recreate the database or just restore the
> appropiate backup file ?

Just restore. But you will have to make sure that SQL Agent is not
running. You may find http://www.dbarecovery.com/restoremsdb.html
helpful.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]