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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Attach to database on External HD

Author  Topic 

twdavis
Starting Member

4 Posts

Posted - 2007-08-21 : 12:37:29
I am getting the error
Unable to open the physical file "E:\Navision SqlData\ForentaSQL_Data.mdf". Operating system error 5: "5(Access is denied.)".
when I try to "attach" to a database located on an external hd. The database files on the external HD were copied from the original server location to the external HD. The file size is 51G+ which is why it is on the external HD.
Can anyone provide me the syntax to do the sp_attach taht will allow me to send the necessary connection string: server, user, pswd etc.

How can I get past this error?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-21 : 12:44:31
Cross posting
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88169



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -