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]
