That error is related to the database and logfile pathnames. When u restore a database it will get the paths and filenames that the db and log were originally stored at, you need to change these to the new location on the new server, and of course exclus ethe logfile info so it doesn't try to restor eit.
Russ > -----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]
