x

We are trying to attach the database of SQL2005 to SQL2008 for upgrade.

We are trying to attach the database of SQL2005 to SQL2008 for upgrade. But we are receiving error while attaching the DB, error says to check the DB using 'DBCC'. 1. The error shows a Table which is their in System Tables but it is not their in the Table object explorer. 2. Unable to create table as it saya already exist. If i try an delete the table it says it's not found. 3. kindly help.
more ▼

asked Sep 24, 2012 at 06:34 AM in Default

RajalNigam gravatar image

RajalNigam
51 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
Does the 2005 database attach and then give you the error or just fail to attach? Have run ran DBCC CHECKDB on your 2005 Database on the 2005 Instance? Does it give the same error? Can you post the actual snippet of text from running DBCC CHECKDB on the database.
more ▼

answered Sep 24, 2012 at 06:40 AM

Tim gravatar image

Tim
36.4k 36 41 139

link textHi Tim thanx a lot for a prompt response. The 2005 database is in use currently and we need to upgrade it to 2008 which is failing due to the table which exist in system tables but it's not their in Table Explorer. I am attaching the snap shot for more information. Thanx once again.

Sep 24, 2012 at 06:49 AM RajalNigam
@RajaNigam, does this corruption appear when you run DBCC CHECKCATALOG on your production 2005 system? In SQL 2000 DBCC CHECKCATALOG was not part of DBCC CHECKDB, but you say you are on 2005 trying to go to 2008. At any rate, it appears you may have metadata corruption in your database. You might want to spend a few minutes reading over some of Paul Randals blogs on corruption.
Sep 24, 2012 at 07:03 AM Tim
Tim..ya I agree that their is particular table corruption issue. As it has created 2 tables with the same name...Is their anyway to delete the table info from system tables as I have tried almost everthing before posting the query?
Sep 24, 2012 at 07:45 AM RajalNigam
Have you tried any of the info outlined Here You still haven't answered me on if this error shows up when you run it in production on your SQL 2005 instance.
Sep 24, 2012 at 07:55 AM Tim
Job well done though. You should schedule a daily or at least weekly job to run dbcc checkdb on your databases to ensure this doesn't happen again. Corruption will occur and you need backups that predate the corruption as you have learned the hard way. At least your issue wasn't user data. A bullet was dodged this time.
Sep 26, 2012 at 06:14 AM Tim
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x7

asked: Sep 24, 2012 at 06:34 AM

Seen: 467 times

Last Updated: Sep 26, 2012 at 06:43 AM