?
Solved

Can't attach  AdventureWorks2008 database

Posted on 2011-09-14
7
Medium Priority
?
463 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 60

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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

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

Accepted Solution

by:
Kevin Cross earned 2000 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 60

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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

765 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