Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
w1102157
Yak Posting Veteran
80 Posts |
 Posted - 2012-07-14 : 13:02:51
|
| 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 exampleunable to open the physical file --- operating system error 5 ( failed to retieve text for this error . reason 15105can anyone provide me any tips on how to attach this databasethanks |
|
|
w1102157
Yak Posting Veteran
80 Posts |
Posted - 2012-07-14 : 13:22:16
|
| anyone? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-14 : 19:49:45
|
| 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
w1102157
Yak Posting Veteran
80 Posts |
Posted - 2012-07-15 : 09:08:20
|
| i am trying to attach the sample adventure work database its an mdf, yes there are the same versions |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-15 : 12:49:39
|
| 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. |
|
|
|
w1102157
Yak Posting Veteran
80 Posts |
Posted - 2012-07-15 : 15:48:22
|
| i tried that i can attach the test database , but the adventure work still wont attach |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-15 : 22:02:03
|
| can you outline steps you did for attaching adventureworks?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
adventureworks database HELP