• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 485
  • Last Modified:

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
0
chtullu135
Asked:
chtullu135
  • 3
  • 3
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
Are you sure you didn't accidentally grab the AdventureWorks2008R2?
Try http://sqlserversamples.codeplex.com/releases/view/30803
0
 
chtullu135Author Commented:
Hello mwvisa1
Actually, that was the first thing I checked.  I'm going to check out the link you sent me.
0
 
venk_rCommented:
Run sp_who2 active and send me the snapshot when you try to attach the db.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
chtullu135Author Commented:
When I try to attach the db, the computer gets locked up
0
 
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
 
chtullu135Author 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now