Error: 823, Severity: 24, State: 2

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Error: 823, Severity: 24, State: 2

Author

Topic

dije
Starting Member

6 Posts

Posted - 2011-03-31 : 10:16:20

Dear All,

Needed Help please...:((

Can't start SQL Service, got this error on Event Viewer.
-->
Error: 823, Severity: 24, State: 2
I/O error (bad page ID) detected during read at offset 0x00000000fac000 in file 'd:\mssql\MSSQL\data\master.mdf'.

thx.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-03-31 : 12:34:08

Get out your backup of master and look up how to restore the system databases (Books Online)

--
Gail Shaw
SQL Server MVP

dije
Starting Member

6 Posts

Posted - 2011-04-01 : 06:46:04

Thx Gail,

But a can't start my SQL Server engine, so can't restore master database...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-04-01 : 08:47:17

Did you try the method shown in BoL? It's not the same as for user databases.

If it doesn't work, then you will need to rebuild the master (and other system) databases. It's an option on setup, again see Books Online for details. Once you've rebuild master, then you can restore the backup (to get your logins and like back).

--
Gail Shaw
SQL Server MVP

addisionphilip
Starting Member

4 Posts

Posted - 2011-04-11 : 08:06:58

I have came across the given below article. This article may help to resolve your problem.

unspammed

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-04-11 : 10:21:52

Utterly useless, as that is for user databases (and terrible advice even then). CheckDB on master won't do much as checkDB won't repair system objects and everything in master is system.

--
Gail Shaw
SQL Server MVP

dije
Starting Member

6 Posts

Posted - 2011-04-12 : 03:18:07

bad news, i dont have master backup, i lost all my scripts (job,agent,dts)..:(
i'm using rebuildm.exe

thx all.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-04-12 : 06:28:02

Yup, you will. To be blunt, that's what you get for not having backups.

--
Gail Shaw
SQL Server MVP

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-18 : 17:31:07

SQL Server version ?

1-Check drive space and user specific space quota restriction

2-Install the named instance and stop the services and copy the master database files of new named instance to the previous instance master database files just remember to take the master database files backup when you are going to copy new one

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-04-18 : 17:37:36

1) Not the problem. 823 is a corruption error, not an out of space error. A portion of the data file has been damaged and contains invalid information.

2) Same effect as rebuild Master - new master database with no logins or other objects, more work than rebuildm installing then uninstalling, may cause problems due to the server name in master not being the same as the instance's name.

p.s. Version is SQL 2000.

--
Gail Shaw
SQL Server MVP

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-18 : 18:23:31

http://en.allexperts.com/q/MS-SQL-Server-1801/O-error-bad-page.htm

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources