Check whether the files have the read only attribute set. If yes,remove this and it should work.

HTH,
Amit
---------- Original Message ----------------------------------
From: "Aaron" <[Email Address Removed] Mon, 22 Mar 2004 13:57:44 -0500

>I tried out sp_attach_db too but I get the same error.
>
>-----Original Message-----
>From: Gentle, Mary [mailto:Mary.[Email Address Removed]
>Sent: March 22, 2004 1:50 PM
>To: Aaron; LazyDBA.com Discussion
>Subject: RE: Attach Database
>
>Does you database have multiple log files?
>
>If so, see http://support.microsoft.com/default.aspx?scid=kb;en-us;271223
>
>-----Original Message-----
>From: Aaron [mailto:[Email Address Removed] Monday, March 22, 2004 11:35 AM
>To: LazyDBA.com Discussion
>Subject: RE: Attach Database
>
>
>It's on a local drive.
>
>I detached the db to remove the transaction log - but now I can't seem to
>re-attach it.
>
>-----Original Message-----
>From: Horton, Joe (LNI) [mailto:[Email Address Removed] March 22, 2004 1:33 PM
>To: 'Aaron'; LazyDBA.com Discussion
>Subject: RE: Attach Database
>
>Is it a local drive? If not use the UNC
>
>__________________________
>Joe Horton
>Database Developer / Software Engineer
>WISHA/Legal Services Software Development Department of Labor and Industries
>Voice (360) 902-5928 fax (360) 902-6200
>
>
>-----Original Message-----
>From: Aaron [mailto:[Email Address Removed] Monday, March 22, 2004 10:30 AM
>To: LazyDBA.com Discussion
>Subject: RE: Attach Database
>
>Everything there is correct. The BOL was just an example. I copied & pasted
>the path from Windows Explorer
>
>-----Original Message-----
>From: Herrera, Jorge [mailto:[Email Address Removed] March 22, 2004 1:25 PM
>To: LazyDBA.com Discussion
>Subject: RE: Attach Database
>
>Aaron,
>
>Check the Path and DB name for correct spelling.
>
>Jorge A. Herrera
>MSSQL DBA
>Chevy Chase Bank
>6200 Chevy Chase Drive
>Laurel, MD. 20707
>[Email Address Removed] Message-----
>From: Aaron [mailto:[Email Address Removed] Monday, March 22, 2004 1:04 PM
>To: LazyDBA.com Discussion
>Subject: Attach Database
>
>
>>From BOL I have used this example to attempt to re-attach a .mdf
>
>EXEC sp_attach_single_file_db @dbname = 'pubs',
> @physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
>
>But, I'm getting this error all the time:
>
>Server: Msg 1813, Level 16, State 2, Line 1 Could not open new database
>'db1'. CREATE DATABASE is aborted.
>Device activation error. The physical file name 'D:\sqldata\db1_log.ldf' may
>be incorrect.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
>cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
>mssqldba-[Email Address Removed] For additional commands, e-mail:
>mssqldba-[Email Address Removed] is to be used for Chevy Chase Bank business purposes only.
>Confidential information should not be sent via email as there is no
>expectation of privacy or integrity of the message through the Internet.
>**********************************************************************
>
>
>**********************************************************************
>This email and any files transmitted with it are confidential and intended
>solely for the use of the individual or entity to whom they are addressed.
>If you have received this email in error please notify the system manager.
>
>This footnote confirms that this email message has been scanned for the
>presence of computer viruses.
>
>Chevy Chase Bank
>**********************************************************************
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
>cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
>mssqldba-[Email Address Removed] For additional commands, e-mail:
>mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get today's
>cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
>mssqldba-[Email Address Removed] For additional commands, e-mail:
>mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Get today's cartoon: http://www.LazyDBA.com
>To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page