Can we update sys.sysschobjs - SQL Server Forums

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

Can we update sys.sysschobjs

Author

Topic

JoyceTan
Starting Member

3 Posts

Posted - 2011-10-28 : 04:26:55

Hi Experts,

I ran a "DBCC CHECKDB WITH NO_INFOMSGS" on this database and I get the following result:

Msg 2570, Level 16, State 3, Line 1
Page (1:181), slot 59 in object ID 34, index ID 1, partition ID 281474978938880, alloc unit ID 281474978938880 (type "In-row data"). Column "modified" value is out of range for data type "datetime". Update column to a legal value.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysschobjs' (object ID 34).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'Toyo'.

Any idea how to fix this?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-10-28 : 04:50:27

Restore from a clean backup.

--
Gail Shaw
SQL Server MVP

JoyceTan
Starting Member

3 Posts

Posted - 2011-10-28 : 04:57:49

quote:
Originally posted by GilaMonster

Restore from a clean backup.

--
Gail Shaw
SQL Server MVP

That's another problem. Restoring from a clean backup is not an option here. :(

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-10-28 : 07:50:50

Please don't tell me you're yet another person without backups of a critical DB.

--
Gail Shaw
SQL Server MVP

JoyceTan
Starting Member

3 Posts

Posted - 2011-10-29 : 23:59:05

quote:
Originally posted by GilaMonster

Please don't tell me you're yet another person without backups of a critical DB.

--
Gail Shaw
SQL Server MVP

Lol. Please don't get me wrong. It's actually a new project under my belt which I have to upgrade their system. However, the upgrade can't take place because of that error. Besides, Mr.Client didn't have a db admin to run all this checks on a daily basis. So, the last clean backup dated back to 2007.

Any more suggestions? Help?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-10-30 : 04:58:52

If it's not too big a DB, script, export and recreate.

Script all objects. Export all data. Recreate a new DB.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources