Torn page problem

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

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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx