By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,826 Members | 815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,826 IT Pros & Developers. It's quick & easy.

Torn page problem

P: n/a
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

Feb 16 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
David Greenberg (da*****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Feb 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.