Solved

Can't attach  AdventureWorks2008 database

Posted on 2011-09-14
7
427 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:chtullu135
  • 3
  • 3
7 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36540337
Are you sure you didn't accidentally grab the AdventureWorks2008R2?
Try http://sqlserversamples.codeplex.com/releases/view/30803
0
 

Author Comment

by:chtullu135
ID: 36540347
Hello mwvisa1
Actually, that was the first thing I checked.  I'm going to check out the link you sent me.
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36540350
Run sp_who2 active and send me the snapshot when you try to attach the db.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:chtullu135
ID: 36540362
When I try to attach the db, the computer gets locked up
0
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 36540496
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
 

Author Closing Comment

by:chtullu135
ID: 36540803
I create the database via SQLCMD mode and  then used sp_attach_db to attach it.  Everything looks fine.  Thanks
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36540856
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql query 34 35
SQL Server 2008 to SQL Server 2016 Replication 8 54
Update in Sql 7 30
CROSS APPLY 4 45
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now