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.
asked Sep 24 '12 at 06:34 AM in Default
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.
answered Sep 24 '12 at 06:40 AM