Make sure the file is not locked - by some copy operation, or it's no already attached - this is the typical message when sql can't lock the file exclusively.
-----Original Message----- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 11:34 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT- SQL (Attach) In my hurry last night I copied my MDF file to disk and forgot the log file :( Is there anyway I can attach the database on my server at work with only the MDF file. I have tried 'All Tasks - Attach Database' this gives me an error about the physical filename for the logfiles being incorrect ..... I tried it in Query Analyser with sp_attach_single_file_db but this gave the same error. Any ideas? Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
