|
Home > Archive > Microsoft SQL Server forum > February 2006 > Torn page problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| David Greenberg 2006-02-16, 7:23 am |
| 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
| |
| Erland Sommarskog 2006-02-17, 7:25 am |
| 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
|
|
|
|
|