Cannot attach .MDF file?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I get the following error trying to attach an .mdf file, the first line is
contained in the windows title bar.
I do NOT have the .LDF file.

Will I be able to salvage this database?

Microsoft SQL-DMO (ODBC SQLState:42000)
Error 1813: Could not open new database 'name'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'c:\program
files\..\name_log.ldf' may be incorrect.

attaching database has failed


.

Relevant Pages

  • Re: Setting AllowBypassKey Property
    ... As long as I open the DB with shift pressed, the app stays in Design mode. ... "Bob Bonta" wrote: ... not tested on v97 database. ... I don't see an option in this reply form to attach a file ... ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL Express backup
    ... I have an interesting situation with my website and I'm not sure if it would be better to ask here or a SQL forum. ... I cannot backup the MDF files because they are constantly in use. ... BACKUP DATABASE TO ... Are you running the mdf file from inside the web site (the auto attach to SQL Express option)? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Having a problem attaching a database
    ... SQL Server Storage Engine Development ... > having trouble attaching the database to pull the required information. ... Select the database that I want to attach (renamed file in new ... Click OK and a message appears asking if I want to create an ldf file. ...
    (microsoft.public.sqlserver.server)
  • Re: attempts to attach db are locking up the server...
    ... happening to the database I was trying to attach, ... Rick ... >What do you meant by Locking while attach? ... >> either don't work or end up locking the system. ...
    (microsoft.public.sqlserver.connect)
  • Re: WSS 2.0 to 3.0 upgrade
    ... Well I ran the inplace upgrade and it didn't report any errors. ... time it took for the database to attach. ... Windows 2003 server, the SQL Server, restoring from backup to WSS 2.0, ...
    (microsoft.public.sharepoint.windowsservices)