Hmmm.. single file attach should work......
-----Original Message----- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 12:03 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT- SQL (Attach) Tried all that still no joy :( When I use the All Tasks - Attach Database I get a green tick for shoes_data.MDF and a redcross for shoes_log.ldf. It seems no matter what I do (enterprise manager or query analyser) it won't attach the database. Anymore ideas? Regards - Paul >From: "Albert Popkov" <[EMAIL PROTECTED]> >Reply-To: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: RE: [ cf-dev ] OT- SQL (Attach) >Date: Wed, 14 Jul 2004 11:44:28 +0100 > > >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] > -- 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] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- 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]
