Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Attaching AdventureWorks Database Expand / Collapse
Author
Message
Posted Tuesday, June 24, 2008 6:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 7, 2009 12:52 AM
Points: 16, Visits: 31
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.
Post #522478
Posted Tuesday, June 24, 2008 6:15 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 42,747, Visits: 35,835
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #522481
Posted Tuesday, June 24, 2008 9:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 7, 2009 12:52 AM
Points: 16, Visits: 31
No, I am attaching it in SQL 2005 Management Studio only.. the is SQL Server Authentication.But still not able to attach it.
Post #522654
Posted Tuesday, June 24, 2008 11:51 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 42,747, Visits: 35,835
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #523030
Posted Wednesday, September 10, 2008 12:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 10, 2008 12:40 PM
Points: 1, Visits: 0
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. :)
Post #567220
Posted Monday, May 9, 2011 6:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 9, 2011 10:57 PM
Points: 1, Visits: 2
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.

Post #1105392
Posted Monday, May 9, 2011 7:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 42,747, Visits: 35,835
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1105397
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse