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 |
|
helpwithsql
Starting Member
2 Posts |
 Posted - 2010-04-11 : 13:16:36
|
| Hi,I am taking an online course in SQL Server. It is the last week of class and my 'team' and I have a project that we have been working on. One of my team members sent me a database from his computer that I needed to download. I downloaded it but now I am having trouble attaching it. I follow all the steps to attach (right click databases, click attach,click add, etc) but SQL Server keeps saying that the file cannot be found. (operating system error 2 - the specified file cannot be found) What am I doing wrong? Any help would be much appreciated as this is a huge part of my grade and I am so stuck! Thank you! PS - I am using SQL server 2008. |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-11 : 13:44:57
|
| I would have been better if he'd sent you a backup. Are you sure you're referencing the correct file/location?------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
 |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2010-04-12 : 06:31:48
|
quote:
Originally posted by helpwithsql
... but SQL Server keeps saying that the file cannot be found. (operating system error 2 - the specified file cannot be found) What am I doing wrong?
Are the SQL Server service and the downloaded files are on different computers?Use the correct UNC (\\computername\share\filename.ext) |
|
|
|
|
|
|
Help attaching a database