SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 adventureworks database HELP		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

w1102157
Yak Posting Veteran

80 Posts
Posted - 07/14/2012 :  13:02:51  Show Profile  Reply with Quote
Hi Guys,

I am currently working on my mcts exam, i amtrying to attach the adventure works database but for some reason i am getting all sorts of errors for example

unable to open the physical file --- operating system error 5 ( failed to retieve text for this error . reason 15105

can anyone provide me any tips on how to attach this database

thanks

w1102157
Yak Posting Veteran

80 Posts
Posted - 07/14/2012 :  13:22:16  Show Profile  Reply with Quote
anyone?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47054 Posts
Posted - 07/14/2012 :  19:49:45  Show Profile  Reply with Quote
we need more info...where are you trying to attach? do you've mdf,ldf files? are destination and source server same versions?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

w1102157
Yak Posting Veteran

80 Posts
Posted - 07/15/2012 :  09:08:20  Show Profile  Reply with Quote
i am trying to attach the sample adventure work database its an mdf, yes there are the same versions
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5152 Posts
Posted - 07/15/2012 :  12:49:39  Show Profile  Reply with Quote
Not necessarily a solution to your problem, but I would try to create a test database (in SSMS), detach it and then try to reattach it. If that succeeds, I would copy the AdventureWorks database to the same location and and use the same user to try to attach it.

While I didn't find any exact description of your problem, googling for 15105 seems to indicate that it is an error related to file system and permissions on files. Doing what I suggested above would help you figure out if it is indeed that.
Go to Top of Page

w1102157
Yak Posting Veteran

80 Posts
Posted - 07/15/2012 :  15:48:22  Show Profile  Reply with Quote
i tried that i can attach the test database , but the adventure work still wont attach
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47054 Posts
Posted - 07/15/2012 :  22:02:03  Show Profile  Reply with Quote
can you outline steps you did for attaching adventureworks?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000