Re: Torn page problem
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 16 Feb 2006 22:38:30 +0000 (UTC)
David Greenberg (davidgr@xxxxxxxxxx) 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@xxxxxxxxxxxxx
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
.
- References:
- Torn page problem
- From: David Greenberg
- Torn page problem
- Prev by Date: Re: SQL Server 2000 conferences
- Next by Date: Re: Recovery model problem; db properities
- Previous by thread: Torn page problem
- Next by thread: Splitting directory and file name
- Index(es):
Relevant Pages
|
