Can't attach AdventureWorks2008 database

I've been trying to attach the AdventureWorks2008 database to no avail.  I've verified that filestream is enabled as well as fully text search.  I am able to attach AdventureWorksDW2008 with no problem but when I try to attach the AdventureWorks2008 database, It looks like it trying to attach - I see the execute task bar  cycling through.  So I'm not sure what is the problem.  I am running MS SQL Server 2008 - Developer version
Juan VelasquezAsked:
Who is Participating?
 
Kevin CrossChief Technology OfficerCommented:
Did you download the files again from the link I sent? It might have been a corruption on previous download. Worth a try.

Also, see what happens if you do not use the GUI: i.e., use sp_attach_db
http://msdn.microsoft.com/en-us/library/ms179877(v=SQL.100).aspx
0
 
Kevin CrossChief Technology OfficerCommented:
Are you sure you didn't accidentally grab the AdventureWorks2008R2?
Try http://sqlserversamples.codeplex.com/releases/view/30803
0
 
Juan VelasquezAuthor Commented:
Hello mwvisa1
Actually, that was the first thing I checked.  I'm going to check out the link you sent me.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
venk_rCommented:
Run sp_who2 active and send me the snapshot when you try to attach the db.
0
 
Juan VelasquezAuthor Commented:
When I try to attach the db, the computer gets locked up
0
 
Juan VelasquezAuthor Commented:
I create the database via SQLCMD mode and  then used sp_attach_db to attach it.  Everything looks fine.  Thanks
0
 
Kevin CrossChief Technology OfficerCommented:
Wonderful. I am very glad to hear that and to have helped. For completeness, here is a better reference if you ever need this in the future: http://msdn.microsoft.com/en-us/library/ms176061(v=SQL.100).aspx
It appears I need to break old habits and start using CREATE DATABASE ... FOR ATTACH instead as sp_attach_db will be deprecated in future versions of SQL. :)

Anyway, best regards and happy coding,

Kevin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.