June 24, 2008 at 6:11 am
Hi,
When I tried attaching the AdventureWorks Database to the SQL 2005 I get the following error.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could you please let me know how can I attach the AdventureWorks Database.
June 24, 2008 at 6:15 am
Looks like you're trying to attach a SQL 2005 database to a SQL 2000 instance.
Adventure works is SQL 2005, hence can only be attached to SQL 2005 or higher.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 9:43 am
No, I am attaching it in SQL 2005 Management Studio only.. the is SQL Server Authentication.But still not able to attach it.
June 24, 2008 at 11:51 pm
The client tool is management studio, I'm asking about the database engine you're trying to attach to. Thing is, that's a SQL 2000-specific error
Open a query to the SQL instance you're trying to attach the database to and run SELECT @@Version
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 12:46 pm
Gila Monster. Thank you very much. I've been trying to figure out what I was doing wrong for the longest time. I didn't realize the error I was getting was because my Sql management studio was connecting to the wrong sql server 2000k instance. You're response to the original posting helped me a lot. 🙂
May 9, 2011 at 6:56 am
Hi,
When I tried attaching the AdventureWorks Database to the SQL 2005 I get the following error.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
May 9, 2011 at 7:01 am
That's a SQL 2000 instance, not SQL 2005 (run Select @@version to prove it).
AdventureWorks is a 2005 or 2008 database and can only be attached to those versions. Downgrade of a database is never possible.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply