Attaching 2005 db to SQL 2008 gets CHECKDB error

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

SQL Server 2008 Forums

SQL Server Administration (2008)

Attaching 2005 db to SQL 2008 gets CHECKDB error

Author

Topic

nhuanlieu
Starting Member

27 Posts

Posted - 2010-03-10 : 19:19:06

hello folks,
After trying to see if attaching SQL 2005 mdf & ldf files to a SQL 2008 and doing CHECKDB thereafter we got a bunch of the error as seen below. We are wondering if anyone knows if that's a known issue. BTW, the backup and restore the db method did not gets the error.

Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3851, State 1: An invalid row (class=60,depid=1,depsubid=0) was found in the system table sys.syssingleobjrefs (class=60).
Msg 8992, Level 16, State 1, Line 1

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-10 : 23:56:21

It's likely that the corruption exists on the source system, your SQL 2005 system. Run DBCC CHECKDB there.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-03-11 : 04:38:02

Agreed. The DB was damaged in some way before the upgrade. Run the following on the SQL 2005 database (if you still have it) before upgrading.


DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources